Forum Discussion

CatoD's avatar
CatoD
Icon for Helper II rankHelper II
4 months ago

Severe Gateway Performance Degradation & High CPU Post-Migration (ASYNC_NETWORK_IO Waits)

Hello everyone, I am looking for some architectural and performance troubleshooting advice. Following a server migration on March 27, 2026, our On-Premises Data Gateway has experienced a massive and...
dataflow
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 months ago
Co-hosted Services: The physical server hosts the Gateway, SQL Server 2019, and Remote Desktop sessions.

There's your problem, right there.   You should never place any other process on a gateway VM, especially not a SQL Server. They will starve each other of resources.

 

Have you changed the MemoryUtilizationPercentageThreshold and/or CPUUtilizationPercentageThreshold parameters?

 

Is this a single VM or a cluster?

  • CatoD's avatar
    CatoD
    Icon for Helper II rankHelper II
    4 months ago

    Thank you for the answer. I'll bring the issue of the gateway and SQL Server on the same VM to the IT department. 
    I've changed CPUUtilizationPercentageThreshold to 80.
    It is single VM.