-
Title
What is meant by Network Wait and Async Network IO in PI -
Description
What is meant by Network Wait and Async Network IO in SQL PI
-
Resolution
RESOLUTION:
Network Wait
"Network Wait" reports that the sessions identified are sending data across the network. This means, the request packet has been delivered to SQL Server, the server has satisfied the request, and now the result set is being transferred via TCP/IP or a Named Pipe to the client console that has requested the information. This phenomenon occurs even for local clients - meaning clients installed on the server where the SQL Server instance is installed - because SQL Server is communicating via TCP/IP or a Named Pipe (in most cases).
ASYNC Network IO
The “async network io” wait types can point to network related issues, but most often are caused by a client application that is not processing results from the SQL Server quickly enough. This will result in filling the network buffers so that SQL Server cannot send more data to the client. Therefore, the process executing the batch will need to wait for the ability to continue sending results to the client.