cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MoorsTech
Advocate I
Advocate I

SQL Server and Gateway on same Server

Hello everyone,

 

we are in the progress of migrating our reporting from an OData datasource to a SQL server datasource as we've seen massive performance improvements when refreshing datasets stored on a SQL server.

 

Originally we were planning to use an Azure SQL Server but we're running into more and more problems and are now considering hosting the Server ourselves. This would of course mean that we also need a gateway to allow refreshes on the PBI service.
Is there any reason why one should not install the gateway on the same machine as the SQL Server other than security/privacy concerns? Can the gateway access a the SQL Server hosted on the same machine?

The obvious upside is of course that the gateway wouldn't have to go through the network to get data from the SQL server, thereby decreasing latency and ultimately increasing throughput.

Thanks!

1 ACCEPTED SOLUTION
GilbertQ
Super User II
Super User II

Hi there

I have had my gateways installed on SQL Servers for quite a while with no issues and it works really well

Just make sure that there is enough CPU & Memory for when your dataset refreshes to ensure that it will not consume too much and slow down your SQL Server. That would be the only things to look out for.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
MoorsTech
Advocate I
Advocate I

Just a little followup:
We have this setup running for about a month now and its working perfectly.
My only concern is memory usage as the gateway does seem to like its RAM. I've limited the SQL server to 45GB memory on a 64gb server to leave some space for the gateway and OS to expand into.

GilbertQ
Super User II
Super User II

Hi there

I have had my gateways installed on SQL Servers for quite a while with no issues and it works really well

Just make sure that there is enough CPU & Memory for when your dataset refreshes to ensure that it will not consume too much and slow down your SQL Server. That would be the only things to look out for.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

We have the same setup (gateway on same machine as sql server) and it has been running fine for almost a year now.

Awesome, thanks a bunch!

If you have any more questions please let the community know.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.