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. |
To open the Disk view of the SQL Diagnostic Manager Resources tab, select the appropriate SQL Server instance, click Resources, and select Disk.
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.
Displays the percentage of time during the sample interval that each disk was not idle.
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.
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.
Displays the number of read and write requests sent to the physical disk the SQL Server instance resides.
Displays the number of errors sent from the physical disk the SQL Server instance resides.
Displays the number of reads per disk per second during the sample interval.
Displays the number of transfers per disk per second during the sample interval.
Displays the number of writes per disk per second during the sample interval.
Displays the average length of time (in milliseconds) for a disk to read during the sample interval.
Displays the average length of time (in milliseconds) for a disk transfer during the sample interval.
Displays the average length of time (in milliseconds) for a disk write during the sample interval.
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.
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.
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.
| | | | | | | |