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 |
|
Simon_L
Starting Member
32 Posts |
 Posted - 2009-06-16 : 07:53:21
|
| Hi Allin the ms white paper on Waits & Queues there is a query to determine avg i.o stallsIf Im running this over a single disc box is there any "ballpark figures" for average amount of stalls per read and write I should be aware of ?many thankssimon--avg stalls per read/writeselect[name],database_id,filetype = case sys.database_files.typewhen 1 then 'Log'when 0 then 'Data'end,io_stall_read_ms,num_of_reads,cast (io_stall_read_ms/(1.0+num_of_reads) as numeric (10,1)) as 'avg_read_stall_ms',io_stall_write_ms,num_of_writes,cast (io_stall_write_ms/(1.0+num_of_writes) as numeric (10,1)) as 'avg_write_stall_ms',io_stall_write_ms+num_of_writes as io_stalls ,num_of_reads+num_of_writes as total_io,cast(io_stall_read_ms+io_stall_write_ms/(1.0+num_of_reads+num_of_writes) as numeric (10,1)) as 'avg_io_stall_ms'from sys.dm_io_virtual_file_stats (11,FILE_IDEX(11))join sys.database_fileson sys.dm_io_virtual_file_stats .file_id = sys.database_files.file_idorder by avg_io_stall_ms descgo |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Simon_L
Starting Member
32 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-16 : 08:58:35
|
I can think there is no "ball park" figure.It heavily depends on what kind of disks you are using, spindles, SAN, NAS and other layers.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
|
|
IO stalls .. help !