System Data Collection Set Reports

The data collector provides an historical report for each of the System Data collection sets. Each of the following reports use data that is stored in the management data warehouse:

  • Disk Usage Summary

  • Query Statistics History

  • Server Activity History

You can use these reports to obtain information for monitoring system capacity and troubleshooting system performance.

The topics in this section provide detailed information about each of these reports, as well as how you can navigate through them using a timeline, text hyperlinks, or graphical links.

Topic

Description

Disk Usage Summary Report

Describes how to use this report, which contains data about disk space usage for all the databases installed on the instance of SQL Server.

Query Statistics History Report

Describes how to use this report, which contains query execution statistics for the most expensive queries.

Server Activity History Report

Describes how to use this report, which contains resource consumption and server activity data for the server and for SQL Server.