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?