June 7, 2019 at 7:34 pm
We have just converted a SQL Server box from a physical server to a vm. I noticed a significant slowness when connect to Object Explorer in Management Studio. My trace shows the duration is over 2 seconds. The normal duration to connect to other servers are around 200 milliseconds. The SQL profiler trace show there are several over 300 milliseconds gaps between each batch. sys.dm_os_wait_stats shows increase on ASYNC_NETWORK_IO. I am the only active user when testing this.
Also browse a network share is slow on that vm. Instead of immediately show the folder/file list, I can see waiting hourglass.
The network team claims there is no problem on the network side. Is there any way I can trace ASYNC_NETWORK_IO in SQL Server profiler? What could cause ASYNC_NETWORK_IO?
Any suggestions or online knowledge links would be appreciated.
Thanks,
Lijun
June 8, 2019 at 8:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
June 10, 2019 at 10:20 pm
This is a good article to get started on troubleshooting that wait type:
Troubleshooting ASYNC_NETWORK_IO, NETWORKIO
And some additional posts about the wait type:
Wait Type Library - ASYNC_NETWORK_IO
SQL Server ASYNC Network IO Wait Type
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply