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

Hi CatoD ,

Thank you for the update. Moving the Gateway to a dedicated VM is a good next step and should help determine whether the current bottleneck is caused by resource contention between Gateway, SQL Server, and RDP workloads.

Once the separation is completed, please monitor:

Gateway CPU and memory utilization
Refresh duration
SQL wait statistics, especially ASYNC_NETWORK_IO
Disk latency on the SQL data/log volumes

It would also be useful to compare the storage and SQL configuration between the old and migrated environments, since the issue started immediately after migration and only affects databases hosted on specific drives.

Thank you.