Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-03-03 : 05:31:44
|
| The wait statswait type networkioNETWORKIO0x800This waittype indicates that the SPID is waiting for the client application to fetch the data before the SPID can send more results to the client application. I have some really large values in this NETWORKIO Does this mean that the SQL is waiting on the network outsideAll our Data is on our SAN.Each minute i have network wait seconds 115.43 andanother time i have One hour i have 5082.58I asked our network guys if there was something with the network and they asking me to give them the meaning of the NETWORKIO and why is SQL telling us this...what direction is it waiting on etcThanks |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-03-03 : 12:11:29
|
| This does mean that SQL is waiting on the outside network. I'm not sure I would worry too much about this one. Let's say you have 115 clients each connected to the server. If each experiences one second of latency over a minute that would be your 115 total seconds of wait time on the network. There is always some network wait time. If a client requests a large result set from the server it usually requests the first group of rows, then the second, then the third, etc. Any time SQL is waiting on the network it will record this wait time.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-03-04 : 07:34:25
|
| Oh i see it it could each connection could be waiting a second then like you mention could be 115 seconds.This happens to be on one SPID....(I see probrably a 100 processes in the current activity on the same table). |
|
|
|
|
|
|
WAIT STATUS