web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

data gateway resource contention

(0) ShareShare
ReportReport
Posted on by 167

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 

 

  • 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)
  • Verified answer
    Pstork1 Profile Picture
    68,271 Most Valuable Professional on at
    Re: data gateway resource contention

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard