November 21, 2016 at 7:37 am
If you run a query.... databasename.dbo.tablename how do I end up with a wait type of "(18ms)ASYNC_NETWORK_IO"?
November 21, 2016 at 8:58 am
dwilliscp (11/21/2016)
If you run a query.... databasename.dbo.tablename how do I end up with a wait type of "(18ms)ASYNC_NETWORK_IO"?
Either the spid is waiting for the client to consume the data or you have a network issue.
😎
November 21, 2016 at 12:52 pm
Interesting... must have been network then... although that is a bit hard to believe.. SSMS did allow me to run sp_whoisactive and return results.. but for some reason this query was not responding... I guess it could have been packet size related, since sp_whoisactive did return only about a dozen results, and the data size per row would have been far lower.
November 22, 2016 at 12:55 am
That wait usually has nothing to do with the network. In most cases it's the client app that's slow to consume the data. Management Studio is a particularly large offender in this regard.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply