Make "disk reads/sec" and "disk writes/sec" available in Performance Monitor

e.knijnenburg

In the Performance Monitor I have the metrics "Disk read bytes/sec" and "Disk write bytes/sec" available. 
However, what I need are "Disk reads/sec" and "Disk writes/sec" which should give me insight into the level of IOPS. 
How do I make these metrics available in the Performance Monitor in an easy way?

Kurt_M

Hi @e.knijnenburg

There isn't going to be an easy way to add this information into Redgate Monitor. It will likely need to be a feature request for these settings to come in.

Even looking into the data repository, there's a couple of views which you can query which show the various writes and reads, but these are still based on the bytes. The Cluster_Machine_LogicalDisk_UnstableSamples_View does store a column for the cumulative writes and reads itself, so that might be useful for you.

Cluster_Machine_LogicalDisk_UnstableSamples_View
Cluster_SqlServer_Database_File_Performance_UnstableSamples_View

e.knijnenburg

Hi Kurt,

Thank you for your quick response.

Best regards,

Eric Knijnenburg