Community Tools Month: Using sp_WhoIsActive to Catch ASYNC_NETWORK_IO
10 Comments
When your SQL Server’s top wait stat is ASYNC_NETWORK_IO, that indicates SQL Server is waiting on the app to ask for the next part of the result set. This is a real pain in the rear to troubleshoot because often these waits happen for really short duration each time – think milliseconds, not seconds. It’s…
Read More