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 |
|
revdnrdy
Posting Yak Master
220 Posts |
 Posted - 2008-12-29 : 17:11:06
|
| Hello;I am running this piece of script to check the IO on our sql server SELECT * FROM sys.dm_io_virtual_file_stats(null,null), sys.databases WHERE sys.databases.database_id =sys.dm_io_virtual_file_stats.database_id; Does anyone know how far back this check goes time wise? When you see a read time of 10000 milliseconds what is that reflecting? Is that an estimate over 1 hour or 24 hours or what?thanks for any feedback.r&r |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2008-12-29 : 17:41:04
|
| Do you mean since the instance was restarted? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Checking IO Statistics..