4

We're running SQL Server 2008 R2.

I'm using SPBlitz and it's saying that I have slow storage writes on Drive H. Blitz defines these as "averaging over 20ms."

But of course, someone asked "How much over?"

Is there a query I can use to determine what the average storage writes is in milliseconds?

Thanks, mh

6

You can query sys.dm_io_virtual_file_stats to find out the read and write latency.

You can use the script from here or here - this is snip from my project of designing a comprehensive SQL Server health checker (this is something internal for now, but planning to opensource the code soon - as a thank you to sql server community !).

Also, read this blog post by Erin Stellato - What Virtual Filestats Do, and Do Not, Tell You About I/O Latency. This blog post has a script that you can use as well.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.