What are the challenges you face when working across database platforms? Take the survey
Options

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?
Tagged:

Best Answers

  • Options
    Kurt_MKurt_M Posts: 187 Silver 1
    edited July 8, 2024 1:32AM Answer ✓
    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

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

  • Options
    e.knijnenburge.knijnenburg Posts: 3 Bronze 1
    Answer ✓
    Hi Kurt,

    Thank you for your quick response.

    Best regards,

    Eric Knijnenburg


Sign In or Register to comment.