Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How am I getting Network_IO wait Expand / Collapse
Author
Message
Posted Thursday, May 8, 2014 9:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:55 AM
Points: 336, Visits: 596
If I am doing a select * from <local table>, then how am I getting a wait type of "Async_Network_IO"?
Post #1568963
Posted Thursday, May 8, 2014 11:23 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 7:09 PM
Points: 593, Visits: 931
ASYNC_NETWORK_IO usually doesn't mean that you are waiting on the network. It usually means that the application is processing the data one row at a time or simply doesn't acknowledge the receipt of data. Have a look at this blog on how to troubleshoot this wait type: http://blogs.msdn.com/b/joesack/archive/2009/01/09/troubleshooting-async-network-io-networkio.aspx



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1569040
Posted Thursday, May 8, 2014 8:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 10:43 PM
Points: 39, Visits: 388
SSMS uses row by row processing. You could see this wait type when you run a query in SSMS on the database server itself. Indeed there is no network involved then.
Post #1569124
Posted Sunday, May 11, 2014 7:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:55 AM
Points: 336, Visits: 596
Keith Tate (5/8/2014)
ASYNC_NETWORK_IO usually doesn't mean that you are waiting on the network. It usually means that the application is processing the data one row at a time or simply doesn't acknowledge the receipt of data. Have a look at this blog on how to troubleshoot this wait type: http://blogs.msdn.com/b/joesack/archive/2009/01/09/troubleshooting-async-network-io-networkio.aspx


Thanks Kieth. I will look at the link this week... I can do a trace to get the plan, and see what it is doing once the big query is run (a lot of queries to temp are run by the program to pull everything together for the generation of the data view). It is a complex series of pre-queries and then the big one, with a lot of sub-queries built in.
Post #1569616
Posted Sunday, May 11, 2014 8:55 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 40,411, Visits: 36,861
Those waits aren't about how the query is written. They occur when SQL has results that it is waiting to send to the client application.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1569625
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse