Forum Discussion
Advocate IIIOn-prem enterprise gateway installation best practice
andrewporter Valid concern, depending on the load that you are going to be putting on the gateway. Is the SQL instance the main source for all your data access needs? Will there be other datasources on the gateway, what type of connection are you using?These and many more questions are why "it depends" is the typical answer.
The recommendations are based on getting the best performance. Kasper De Jonge wrote up a nice blog that touches on some of your question here
If you are using your SQL DB, especially in Direct Query, then yes it would be more advantagous to have the Gateway on the same server. But the gateway will obviously consume resource and increase the SQL traffic, and it could be significant if there are many users interacting with the report in DQ mode, or if reprocessing the dataset takes a long time. Hope that helps a bit.
Community SupportHi andrewporter,
The most import thing to consider is Requirements. If the server run the SQL Server meet the requirement, it would better to install the data gateway on the same machine. You can also install on a dedicated server if the network is good and that server meet that requirement. Personally, I would suggest you install on the same server which hosts SQL server instance if that server can afford.
Best Regards,
Qiuyun Yu