Share
Report
167I 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
- You could install other applications on the gateway machine, but this may degrade gateway performance. If you do install other applications on the gateway machine, be sure to monitor the gateway closely to check if there's any resource contention.
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.
I have the same question (0)
All responses (
Answers (
