SQL 2008 - Suspended - ASYNC_NETWORK_IO
I simulated the migration of a server version of SQL Server 2000 to SQL Server 2008.
I'm testing database with the applications.
In some cases, there are procedures that they stay with the status "suspended".
After doing a select in sys.dm_os_waiting_tasks wait_type is found that the "ASYNC_NETWORK_IO.
After migrating, I ran the DBCC DBREINDEX for all tables.
Can anyone help me?
ASYNC_NETWORK_IO is the wait state that is shown while either:
- Rows are being spooled to the client
or
- Rows are being spooled from the client in a bulk load (for example, using the SqlBulkCopy class in .NET)
It's a good idea to check that the applications are reading the result set entirely, and properly disposing of the connection once finished. Another thing to check is that the result set of the procedures in question is the same as it was under SQL 2000, to make sure that a difference is not causing the application to behave differently.
