986
Part VII: Monitoring and Auditing
Disk Usage Summary
The Disk Usage Summary report shows the starting size, current size, average growth and
trend of your databases, and log fi les. Figure 43-12 shows the report for the development
system.FIGURE 43-12
The Disk Usage Summary report.Server Activity History
The Server Activity History report shows information about resource utilization such as
memory usage, percentage of CPU, disk I/O, and network usage. In addition, it shows infor-
mation about operations that can impact the performance of the server including waits,
locks, logging, compilations, transactions, connections, and more.. Figure 43-13 shows the
Server Activity History Report.Query Statistics
The Query Statistics report shows information about the queries that have been run and
highlights the top queries by total CPU. It can identify queries that cause bottlenecks,
or just consume too many resources. Figure 43-14 shows the report for the development
system.c43.indd 986c43.indd 986 7/31/2012 10:18:45 AM7/31/2012 10:18:45 AM
http://www.it-ebooks.info