The Disk tab allows you to view key statistics on the way your disks are used on the computer hosting your SQL Server instance. This allows you to analyze your disk performance for any performance bottlenecks that may be occurring.
Disk information is displayed in four charts that display the drives the computer on which the SQL Server instance is located. You can pick which four charts you view by selecting from the drop-down list at the top of each chart. You can select from the following charts:
You must have OS metrics enabled to show the information in the charts on the Disks tab.
Access the Disk view
To open the Disk view of the SQL Diagnostic Manager Resources tab, select the appropriate SQL Server instance, click Resources, and select Disk.
Disk tab details
Disk Busy Total
Displays the percentage of time during the sample interval that the disk was not idle for all the disks(combined) on the server that the SQL Server instance resides.
Disk Busy Per Disk
Displays the percentage of time during the sample interval that each disk was not idle.
Average Disk Queue Length Total
Displays the average length of the disk queue during the sample interval for all disks (combined) on the server that the SQL Server instance resides.
Average Disk Queue Length Per Disk
Displays the average length of the disk queue during the sample interval for all disks (individual) on the server that the SQL Server instance resides.
SQL Server Physical I/O
Displays the number of read and write requests sent to the physical disk the SQL Server instance resides.
SQL Server Physical I/O Errors
Displays the number of errors sent from the physical disk the SQL Server instance resides.
Disk Reads/Second Per Disk
Displays the number of reads per disk per second during the sample interval.
Disk Transfers/Second Per Disk
Displays the number of transfers per disk per second during the sample interval.
Disk Writes/Second Per Disk
Displays the number of writes per disk per second during the sample interval.
Average Disk ms/Read Per Disk
Displays the average length of time (in milliseconds) for a disk to read during the sample interval.
Average Disk ms/Transfer Per Disk
Displays the average length of time (in milliseconds) for a disk transfer during the sample interval.
Average Disk ms/Write Per Disk
Displays the average length of time (in milliseconds) for a disk write during the sample interval.
VM Disk Usage
Displays the amount of data read from and written to disk in KB per second for this virtual machine during the sample interval. For additional information about how SQL Diagnostic Manager works with virtual machines and collects metrics, see How SQL Diagnostic Manager works with a virtual environment.
Host Disk Usage
Displays the amount of data read from and written to disk in KB per second for the host server during the sample interval. For additional information about how SQL Diagnostic Manager works with virtual machines and collects metrics, see How SQL Diagnostic Manager works with a virtual environment.
Understanding your chart data and refresh interval
SQL Diagnostic Manager charts provide data whether collected in real-time or as part of a scheduled collection event. For additional information about how SQL Diagnostic Manager displays your chart data, see Charts.