The Disk Details report lets you view key disk metrics of a monitored SQL Server instance and specific disk drive over a specified period of time. To successfully monitor OS metrics, make sure that WMI/OLE automation is enabled on the monitored instance. Check Show Tabular Data to display results in a single tabular or grid format.
This report generates the following graphs: Disk Time Per Read (MS), Disk Time Per Transfer (MS), Disk Time Per Write (MS), Disk Reads Per Second, Disk Transfers Per Second, and Disk Writes Per Second.
When to run this report
You should run the Disk Details report to analyze the six key metrics for disk speed, such as disk time per read or disk reads per second.
How SQL Diagnostic Manager calculates metric values on this report
Most values on the Disk Details report correlate with the related SQL Server metric.
However, some metric values represent averages over time. Likewise, a few metric values are based on performance algorithms that use multiple statistics to calculate a more accurate metric.
You can access our Customer Support Portal for more information about the algorithm used to calculate a specific metric.
- How does SQL Diagnostic Manager gather statistics from monitored SQL Servers? - Solution #00000055
- How to customize existing reports used with Reporting Services? - Solution #00000307
Customize your report and use the Chart filter to include either the average or maximum disk details.