Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

View a Collection Set Report (SQL Server Management Studio)

After you have configured the management data warehouse, you can view a collection set report in SQL Server Management Studio. Reports are provided for the System Data collection sets that are installed during Setup. The reports include the following:

  • Disk Usage Summary

  • Query Statistics History

  • Server Activity History

This procedure displays the report for the Disk Usage collection set. You can follow the same general procedure to view the reports for the other System Data collection sets.

To view a collection set report

  1. The tables for a report are created the first time that the collected data is uploaded. If you try to view a report before this first upload, an error occurs and no report is displayed. To upload data for the Disk Usage collection set, in Object Explorer, expand the Management folder, expand Data Collection, expand System Data Collection Sets, right-click the Disk Usage collection set, and then click Collect and Upload Now.

  2. To view the report, in Object Explorer, expand the Management folder, right-click Data Collection, point to Reports, point to Management Data Warehouse, and then click Disk Usage Summary.

    Note Note

    Some reports might display a calendar button under the data collection timeline. Click this button to access the Data Collection Report Calendar.

Data Collection Report Calendar

Use this dialog box to specify the start date, start time, and duration of the data that you want to report on. For example, you may want to report on the disk usage activity of a server for a specific 12-hour period last Wednesday.

Start date

Enter a beginning date for the report data, or select one from the calendar.

Start time

Enter a beginning time for the report data or specify one by clicking the arrows.

Duration

Specify the time range to include in the report. The default value is 240 minutes. The possible values to select from are 15 minutes, 60 minutes, 240 minutes (4 hours), 720 minutes (12 hours), and 1440 minutes (24 hours).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.