SQL Server 2005 – Performance Dashboard installation steps


Hi,

To get the Performance Dashboard for SQL Server 2005 installed you must follow these steps:

1. Download the installation package from Microsoft Web Site:

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

2. Install the MSI where you have the SQL Server Management Studio installed

3. Locate the Performance Dashboard folder, normally you should find it here:

C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard

4. Edit the setup.sql file and append the code available in this blog post, to the end of the file:

http://blogs.msdn.com/chrissk/archive/2008/06/19/performance-dashboard-error-difference-of-two-datetime-values-caused-an-overflow-at-runtime.aspx

5. Connect to every instance that you want to see information using the Performance Dashboard and then run the setup.sql script against each SQL Server instance.

 

After these 5 steps you should get a similar view like the image above, using the Reports option in the SSMS, then choose the Custom Reports option, navigate to the Performance Dashboard folder and then select the performance_dashboard_main.rdl file. After this, you must accept all the security alerts:

 

image

“The dashboard distribution is a set of .RDL files, a SETUP.SQL script, and this help (PerfDash.chm) file. The SETUP.SQL script creates a new schema (MS_PerfDashboard) in the msdb database and a set of procedures and functions referenced by the reports.  The dashboard does not create a database or tables or store any trending data over time.  It relies solely on the information made available in the SQL Server 2005 dynamic management views (DMVs).”

Cheers,

Comments (0)

Skip to main content