Skip to content

Latest commit

 

History

History
51 lines (36 loc) · 2.95 KB

view-a-collection-set-report-sql-server-management-studio.md

File metadata and controls

51 lines (36 loc) · 2.95 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords
View a collection set report (SSMS)
View a collection set report in SQL Server Management Studio.
MashaMSFT
mathoma
randolphwest
12/28/2023
sql
supportability
how-to
sql13.swb.dc.reporthistory.calendar.f1
collection sets [SQL Server], viewing reports
reports [SQL Server], viewing collection set

View a collection set report (SQL Server Management Studio)

[!INCLUDE SQL Server]

After you have configured the management data warehouse, you can view a collection set report in [!INCLUDE ssManStudioFull]. Reports are provided for the System Data collection sets that are installed during Setup. The reports include the following options:

  • 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.

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 select 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 select Disk Usage Summary.

    Some reports might display a calendar button under the data collection timeline. Select 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 might 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 selecting 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).

Related content