[ACCEPTED]-Suspended status in SQL Activity Monitor-suspend
The wait type "Async_Network_IO" means that 12 its waiting for the client to retrieve the 11 result set as SQL Server's network buffer 10 is full. Why your client isn't picking up 9 the data in a timely manner I can't say.
The 8 other case it can happen is with linked 7 servers when SQL Server is querying a remote 6 table, in this case SQL Server is waiting 5 for the remote server to respond.
Something 4 worth looking at is virus scanners, if they 3 are monitoring network connections sometimes 2 they can get lagged, its often apparent 1 by them hogging all the CPU.
Suspended means it is waiting on a resource 4 and will resume when it gets its resource. Judging 3 from the sizes you are pulling back, it 2 seems you are in an OLAP type of query.
Try 1 the following things:
- Use NOLOCK or set the TRANSACTION ISOLATION LEVEL at the top of the query
- Check your execution plan and tune the query to be more efficient
More Related questions