The Disk Size 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.
You must have OS metrics enabled to show the information in the charts on the Disks tab.
Access the Disk Size view
You can open the Disk Size view by selecting the appropriate SQL Server instance, and then clicking Disk Size in the Views group of the Resources tab. Click image to view full size.
Disk Size tab details include:
- Drive Name
- Total Size (MB)
- Used (MB)
- Free Disk (MB)
- SQL Data Used (MB)
- SQL Data Free (MB)
- SQL Log (MB)
- Other Files (MB)
Current Disk Usage chart
The Disk size tab includes a chart that displays the current disk usage. The drop-down list allows you to choose to view the data in megabytes or percentages.
Understanding your chart data and refresh interval
SQL Diagnostic Manager charts provide data whether collected real-time or as part of a scheduled collection event. For additional information about how SQL Diagnostic Manager displays your chart data, see Charts.
You can print, export to Excel, or save the Current Disk Usage chart image.