Tag: database management

author:

Database

SQL Server CXPacket Wait Type


When are CXPACKET waits a problem? Note: This article, by Thomas LaRock, was posted 8/19/2013 and supercedes the previous version. This update has been made in response to comments made on the original article text. The SQL Server CXPACKET wait type is a result of parallel query execution …



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 …