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 |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2009-02-17 : 09:53:32
|
| I have recently installed SQL Server 2008 on my PC. I am using the Activity Monitor to look at our SQL Server 2005 server. In the Waits stats, it has Network I/O = 257307 cumulative wait (sec). How can I get more information about this, e.g. which queries / users / databases etc had highest wait time/ Average wait etc? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-17 : 10:55:42
|
| Look at I/O related DMV. Books online has details about them. |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-02-17 : 11:43:35
|
| So Activity Monitor can not be used to show more detail? |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-02-18 : 09:04:30
|
| Does anyone have any pointers on how to pinpoint where the network i/o wait is coming from. I've looked at a number of DMV's and Standard reports, a lot of different websites etc, but I can't seem to find how to identify source of the Wait other than vague references to client applications.- Or how to alleviate the problem - or is it safe to ignore it? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 12:02:57
|
| Did you check standard reports for I/O? Also Performance monitor has counters for Network as well. |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-02-24 : 03:20:47
|
quote:
Originally posted by darkdusky
Does anyone have any pointers on how to pinpoint where the network i/o wait is coming from. I've looked at a number of DMV's and Standard reports, a lot of different websites etc, but I can't seem to find how to identify source of the Wait other than vague references to client applications.- Or how to alleviate the problem - or is it safe to ignore it?
Have a look at this article[url]http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1265214,00.html[/url]you can also tweak these queries as per your needs...[url]http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1265214,00.html[/url]Regards,Ahmad Osama |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-02-24 : 04:26:14
|
| Ahmad - some excellent queries - I'll run through thesethanks |
|
|
|
|
|
|
|
|
network i/o wait