Author |
Topic  |
|
shaggy
Posting Yak Master
India
248 Posts |
Posted - 02/02/2013 : 03:09:43
|
select * from dm_io_virtual_file_stats(dbid(),null) avg_io_stall_ms for some of my DB files by average it is 400 ms
is it possible that there is either a disk bottleneck or that high reads and writes are occurring on that drive
All DB files are in separate drives.
Is it like (Average Disk sec/read or write )> 20 ms is a IO botleneck.
Pls can anyone explain in this whether am in a right track in identifying problem. |
|
tkizer
Almighty SQL Goddess
USA
38200 Posts |
|
tkizer
Almighty SQL Goddess
USA
38200 Posts |
|
shaggy
Posting Yak Master
India
248 Posts |
Posted - 02/04/2013 : 02:04:20
|
Thanks tkizer
|
 |
|
|
Topic  |
|