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?
asked Mar 31, 2010 at 05:59 PM in Default
ASYNC_NETWORK_IO is the wait state that is shown while either:
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.