SQL Server 2005 Performance Dashboard Reports - Professional SQL Server 2005 Performance Tuning - page 492

OtherReports
In addition to the reports already shown, there are a number of other reports available in the Performance
Dashboard Reports, including the following:

❑ Blocking

❑ Buffer IO

❑ Buffer Latch

❑ Database Overview

❑ Expensive Queries

❑ Generic Waits

❑ Historical IO

❑ Historical Waits

❑ Latch Waits

❑ Missing Indexes — XML Showplan

❑ Page Details

❑

Performance Dashboard

❑ Plan Guide

❑ Query Plan

❑ Recent CPU Utilization

❑ Requests Overview

❑ Session Details

❑ Session Overview

❑ Traces

For use cases and more information about each of these reports, read the Performance Dashboard
Reports Help file. The PerfDash.chm file can be found in your installation directory. The default path
is \ %ProgramFiles \ % \ Microsoft SQL Server \ 90 \ tools \ PerformanceDashboard \ PerfDash.chm.

Limitations
The SQL Server 2005 Performance Dashboard Reports brings performance troubleshooting to the masses.
It's no longer a secret art to combine a few DMVs and then try to make sense of tables of data. This is a
big step in the right direction of packaging common uses into these reports. Before you get too excited,
keep the following in mind:

❑ They only work with Service Pack 2 and later.

❑

They only present a snapshot data.

❑ They do not compare data to a baseline.