question

Felipe avatar image
Felipe asked

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?

sql-server-2008sql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Matt Whitfield avatar image
Matt Whitfield answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.