Previous Install Master Data Services Manual Install Install System Views Map Next

Install SQL Performance Dashboard

FineBuild can install and configure SQL Performance Dashboard as part of the SQL Server install process.
If you do not want to include SQL Performance Dashboard in your FineBuild install, then do not download it.

SQL Performance Dashboard was produced by Microsoft. It was chosen to be included in FineBuild because it provides a number of Custom Reports that assist the management of SQL Server.

SQL Performance Dashboard home page http://blogs.msdn.com/b/sqltips/archive/2007/03/29/sql-server-2005-performance-dashboard-reports.aspx
SQL Performance Dashboard download for SQL 2012 http://go.microsoft.com/fwlink/?LinkID=239688
SQL Performance Dashboard download for SQL 2005 http://www.microsoft.com/download/en/details.aspx?id=22602
SQL Performance Dashboard tutorial http://www.sql-server-performance.com/2007/bm-performance-dashboard-2005/2/
SQL Performance Dashboard tutorial http://blogs.msdn.com/b/sqlserverfaq/archive/2011/07/07/what-s-performance-dashboard-and-how-it-can-help-in-troublehsooting-sql-issues.aspx

FineBuild SQL Performance Dashboard Install

Automated silent installation of SQL Performance Dashboard is performed by Process Id 4SG and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupPerfDash FULL Yes Yes Yes Yes Yes
SetupSQLTools No No No No No
SetupPerfDash WORKSTATION Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes
SetupPerfDash CLIENT Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes

In order to maintain compatibility with older versions of SQL FineBuild, the parameters InstPerfDash and InstSQLTools can also be used.

FineBuild also uses the following parameters to help install SQL Internals Viewer:
Parameter SQL Version Default Value Description
PerfDashmsi SQL 2012 and above SQLServer2012_PerformanceDashboard.msi Name of SQL Performance Dashboard install file
PerfDashmsi Other versions SQLServer2005_PerformanceDashboard.msi Name of SQL Performance Dashboard install file

SQL Performance Dashboard will be installed with CLIENT and WORKSTATION builds, but not with a FULL build.
If you want to install it with a FULL build, the following parameter should be added at run time:
/SetupSQLTools:Yes
The original version of SQL Performance Dashboard was designed for SQL 2005, but can be used for SQL 2008 and SQL 2008 R2. However, if used on SQL 2008 or SQL 2008 R2 it will not show details of Wait types introduced with these versions. A new version of Performance Dashboard is available for SQL 2012.

The FineBuild install for Performance Dashboard includes the following:
  • Perform a SQL Performance Dashboard install
  • Make reports available to SQL Server

Manual SQL Performance Dashboard Install

The following steps show what you would have to do to install SQL Performance Dashboard manually. FineBuild does all of this work for you automatically.

SQL Performance Dashboard Install

1) Navigate to the Additional Components folder and double-click on the relevant file:

SQL2012, SQL2014 SQLServer2012_PerformanceDashboard.msi
SQL2005, SQL2008, SQL2008R2 SQLServer2005_PerformanceDashboard.msi

PerfDash Explorer.png
2) The Welcome screen is displayed. Click Next to continue.
PerfDash Welcome.png
3) Accept the License agreement. Click Next to continue.
PerfDash License.png
4) Enter the Registration Information and click Next to continue.
PerfDash Registration.png
5) Accept the Feature Selection and click Next to continue.
PerfDash Feature.png
6) Setup is ready to install. Click Install to continue.
PerfDash Ready.png
7) The install has completed successfully. Click Finish to end.
PerfDash Complete.png

Make Reports Available to SQL Server

A number of components have to be installed on SQL Server.

1) The performance dashboard reports must be made available to the DBA. Copy all report files (.rdl)

Source Destination
C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard E:\DBAFiles\SQL Server Management Studio\Custom Reports

PerfDash Copy.png
2) If you are installing SQL Performance Dashboard for SQL 2005, SQL 2008 or SQL 2008 R2 then the setup.sql file must be updated.

See http://blogs.msdn.com/b/vascov/archive/2008/09/30/using-performance-dashboard-with-sql-server-2008.aspx for details of why this is necessary.

Edit C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard\setup.sql and make the following change

Old Value New Value
cpu_ticks / convert(float, cpu_ticks_in_ms) ms_ticks

3) Run the SQL script setup.sql from the C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard folder. This process must be done for every SQL Server instance that is installed.
PerfDash Setup.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install Master Data Services Top Install System Views Map Next

Last edited Oct 23, 2014 at 11:35 AM by EdVassie, version 8