Install SQL Performance Dashboard
| Previous Install Master Data Services | Manual Install | Install System Views Map Next |
|---|
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.
| Item | Location |
|---|---|
| SQL Performance Dashboard home page | https://techcommunity.microsoft.com/t5/sql-server-support/sql-server-2005-performance-dashboard-reports/ba-p/315415 |
| SQL Performance Dashboard download for SQL 2012 | https://www.microsoft.com/en-us/download/details.aspx?id=29063 |
| SQL Performance Dashboard download for SQL 2005 | The download for the SQL 2005 Performance Dashboard is no longer available |
| SQL Performance Dashboard tutorial | https://www.sql-server-performance.com/bm-performance-dashboard-2005/ |
| SQL Performance Dashboard tutorial | https://solutioncenter.apexsql.com/how-to-troubleshoot-sql-server-performance-problems-using-the-ssms-performance-dashboard/ |
| SQL Performance Dashboard video | https://www.youtube.com/watch?v=cVdfhBVmeig |
Automated silent installation of SQL Performance Dashboard is performed by Process Id 4SG and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupPerfDash: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2017 | /SetupPerfDash: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2016 | /SetupPerfDash: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2014 | /SetupPerfDash: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2012 | /SetupPerfDash: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008R2 | /SetupPerfDash: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008 | /SetupPerfDash: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2005 | /SetupPerfDash: | Yes | Yes | Yes |
| /SetupSQLTools: | No | 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 Performance Dashboard:
| 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:
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.
-
Navigate to the Additional Components folder
Double-click on the relevant file:
Platform File SQL2012 and above SQLServer2012_PerformanceDashboard.msi SQL2005, SQL2008, SQL2008R2 SQLServer2005_PerformanceDashboard.msi 
-
The Welcome screen is displayed
Click Next to continue
-
Accept the License agreement
Click Next to continue
-
Enter the Registration Information
Click Next to continue
-
Accept the Feature Selection
Click Next to continue
-
Setup is ready to install
Click Install to continue
-
The install has completed successfully
Click Finish to end
A number of components have to be installed on SQL Server.
-
The performance dashboard reports must be made available to the DBA
Copy all report files (.rdl) as described below:
Source Destination C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard E:\DBAFiles\SQL Server Management Studio\Custom Reports 
-
If you are installing SQL Performance Dashboard for SQL 2008 or SQL 2008 R2
The setup.sql file must be updated because the name of the item used to hold CPU usage has been changed
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 -
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
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
| Previous Install Master Data Services | Top | Install System Views Map Next |
|---|