x

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?

more ▼

asked Mar 31, 2010 at 05:59 PM in Default

avatar image

Felipe
262 23 23 26

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Mar 31, 2010 at 06:13 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2188
x1154

asked: Mar 31, 2010 at 05:59 PM

Seen: 3162 times

Last Updated: Mar 31, 2010 at 05:59 PM

Copyright 2017 Redgate Software. Privacy Policy