August 8, 2011 at 9:25 am
Hi,
So im trying to understand how our SQL server is using the SAN. (which DBs are heavy Read or Write, Is tempdb used a lot etc)
I found a free download by Glenn Berry and the guys who wrote the DMV book for Simple Talk (http://www.bradmcgehee.com/2010/07/free-sql-server-dmv-starter-pack/[/url]). And it has a script that i quote "Calculates average stalls per read, per write, and per total input/output for each database file."
This sounds perfect! but in my naivety im not sure what "stalls are? is it another word for waits? Whats the difference between "io_stalls_read_ms" and "num_of _reads"?
Hope someone can help
S
August 10, 2011 at 1:51 pm
io_stall_read_ms is the total time the user had to wait for the reads for the file whereas number of reads is the total number of reads on that file.
stall time is in milli seconds.
-Roy
August 10, 2011 at 1:53 pm
Hi Roy,
Yes i should have updated that i found the answer already.
Thanks for the input though 🙂
S
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply