ASYNC_NETWORK_IO Waits SQL Server 2005 2008 2012 2014 2016
ASYNC_NETWORK_IO Wait type in SQL 2005 2008 2012 2014 or 2016 are associated with either a Network Performance issues in the Environment or a the client application is not processing results quickly enough from SQL Server.
As always, if you are One of the DBA’s who check Top Waits Stats on SQL Servers to get a insight on what is SQL Server waiting on actually for this performance issues. Below few tips on troubleshooting ASYNC_NETWORK_IO Waits SQL Server
The Top Waits Stats rollup query is used to find the Top Waits SQL Server is waiting on from last restart of SQL Server.
The First thing when … Read the rest