O'Reilly logo

SQL Server 2008: Administration in Action by Rod Colledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15.5. Reporting

In closing our coverage of the data collection platform, let's take a look at the standard reports. Each of these can be accessed in SQL Server Management Studio by right-clicking Data Collection and choosing Reports > Management Data Warehouse. The data shown in the resultant report will be filtered for the server from which the report was run. Let's start with the Disk Usage Summary report.

15.5.1. Disk Usage Summary

The initial view of the Disk Usage Summary report, as shown in figure 15.9, presents a view of each database's disk usage within the instance.

Figure 15.9. The Disk Usage report includes trend lines and average growth per day for both data and log files. 
Figure 15.10. Drilling down from the Disk Usage report ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required