February 19, 2003 at 3:10 am
Can anyone tell me:
Is there a way that, using SQL server I can capture the disk i/o stats that are shown in WinNT Task Manager(columns I/O Read Bytes + I/O Write Bytes).
Or is there a way that I can capture this information per committed query?
What I am trying to achieve is that I use getdate() at the same time as caputuring the above info on a 5/10 minute basis - then I can get an average over a given period of time.
TIA
February 19, 2003 at 3:18 am
Yep you can, have a look at the script
Log DISK IO statistics per Database file!!!
that is posted on this site, i think it does what you are asking.
It stores the data in a database as well so you can build
statistics over a longer period of time.....
February 19, 2003 at 5:35 am
I am probably just being a complete monkey, but I cannot find anything using the search!
Help!
February 19, 2003 at 5:57 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply