Category: Database

author:

Database

SQL Server ASYNC Network IO Wait Type


THIS ARTICLE HAS BEEN RECENTLY UPDATED AND CONTAINS NEW, TECHNICAL INFORMATION Note: For SQL2000 this wait is called NETWORKIO. The ASYNC_NETWORK_IO wait indicates that one of two scenarios are happening. The first scenario is that the session (i.e., SPID) is waiting for the client …