
I recently installed a data gateway on a prod server. This same server hosts sql server and a data warehouse application that is used daily. I noticed after installation of the data gateway the performance of updates on our data warehouse databases grew significantly worse. After an uninstall my update times when back to normal. After reading Microsoft doc I came across the consideration given below:
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
I installed the data gateway to use the sql server connector with power automate. This made my flows more efficient, but I'm confused how I can workaround these performance issues.
The on-premises gateway needs to be on the local network with the SQL server, but doesn't need to be installed on the server itself. The way to fix your performance problem is to install the gateway on a different server that has more available processing capacity or the best approach would be to install it on a dedicated server.