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 |
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-02-02 : 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 driveAll 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
38200 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-02-04 : 02:04:20
|
Thanks tkizer |
|
|
|
|
|