Disk Usage Summary Report

The Disk Usage Summary report contains data about disk space usage for all the databases in the instance of SQL Server. The data provided in the reports is obtained by using the Disk Usage collection set, which uses the Generic T-SQL Query collector type.

You can access the Disk Usage Summary report from Object Explorer. To view the report, expand the Management folder, right-click Data Collection, point to Reports, point to Management Data Warehouse, and then click Disk Usage Summary. For more information, see How to: View a Collection Set Report.

Disk Usage Collection Set Report

The Disk Usage Collection Set report provides an overview of the disk space used for all databases in the instance of SQL Server, and growth trends for the data and log files for each of these databases.

  • The summary table displays the start size (in megabytes) and the current size of all the databases installed on the server that the data collector is monitoring.

  • Trend and average growth information is shown graphically and numerically for both data and log files.

Disk Usage Collection Set - Database: <database_name> Subreport

The Disk Usage Collection Set - Database: <database_name> subreport is displayed when you click a trend line for a specific database or log file in the summary table of the Disk Usage Collection Set report. This report provides a graphical representation of growth trends in disk space usage over the period of the report. Disk usage is organized and reported by used space, data space, unallocated space, and index space for data files, and used space and unused space for log files.

The table below the graph lists data collection times and corresponding usage data.

Disk Usage for Database: <database_name> Subreport

The Disk usage for database:<database_name> subreport is displayed when you click a database name in the summary table of the Disk Usage Collection Set report. This report provides a numerical and graphical breakdown of space usage by the data and transaction log files of the database. Space usage for data files is categorized as a percentage allocated to index pages, unallocated space, data pages, and unused space. These categories are defined as follows:

Category

Definition

Index

The amount of disk space used to hold index pages.

Unallocated

The amount of disk space available to the database but not yet allocated to any object.

Data

The amount of disk space used by data pages.

Unused

The amount of disk space allocated to one or more objects, but not yet used.

Space usage for the transaction log file is categorized as used space and unused space.

Autogrow and autoshrink events are reported for both the data and log files if these events have occurred in the database. The report displays the start time and duration of each event and the resulting change in file size.

The disk space used by each data file in the database is reported. The space reported as Space Reserved is the amount of used space plus the space allocated to the file but not yet used. The space reported by Space Used is the actual space currently used by the file, excluding allocated space.