The Microsoft “SQL Server 2005 Performance Dashboard Reports” is an add-in package that contains set of reports to monitor and resolve performance problems on SQL Server 2005 database server (or even on SQL server 2008 by changing few codes). These reports get data from the many Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) available in SQL Server 2005/2008. This is not the replacement for other performance tools but one of additional tools to identify and troubleshoot performance bottleneck.
The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later. Reporting Service is NOT a requirement to run these reports.
You can download this free add-in from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc.
After installing the downloaded package add the “performance_dashboard_main.rdl” as custom report in SSMS and run setup.sql. You will get the installed reports and setup.sql in the folder where the Performance Dashboard report definitions were installed. Typically it is “C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard”.
Now the initial setup of the Performance Dashboard is done and it is ready for use like any other built-in reports already offered by Management Studio.