Disk Speed Check

I regularly need to check the speed of disks on servers I jump on to. I found an excellent resource from a Microsoft Blogger named David Pless;

https://blogs.msdn.microsoft.com/dpless/2010/12/01/leveraging-sys-dm_io_virtual_file_stats/

It uses a number of counters from sys.dm_io_virtual_file_stats most of which are in milliseconds and bytes so they need to be aggregated for readability.

The script wasn’t *exactly* what I was after so I modified it to suit my needs. Here’s a sample of the output;

You’re more than welcome to grab a copy of this from my github. Feel free to make a pull request if you feel anything can be improved by changing this;

https://github.com/RichBenner/PersonalCode/blob/master/Disk_Speed_Check.sql