How can we help you today? How can we help you today?

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

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?
e.knijnenburg
0

Comments

2 comments

  • 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

    Kurt_M
    0
  • e.knijnenburg
    Hi Kurt,

    Thank you for your quick response.

    Best regards,

    Eric Knijnenburg


    e.knijnenburg
    0

Add comment

Please sign in to leave a comment.