Install SQL Performance Dashboard - SQL-FineBuild/Common GitHub Wiki

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

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:

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:

Top

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

    Double-click on the relevant file:

    Platform File
    SQL2012 and above SQLServer2012_PerformanceDashboard.msi
    SQL2005, SQL2008, SQL2008R2 SQLServer2005_PerformanceDashboard.msi

    ![Explorer](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/PerfDash Explorer.png)

  2. The Welcome screen is displayed

    Click Next to continue

    ![Welcome](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/PerfDash Welcome.png)

  3. Accept the License agreement

    Click Next to continue

    ![License](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/PerfDash License.png)

  4. Enter the Registration Information

    Click Next to continue

    ![Registration](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/PerfDash Registration.png)

  5. Accept the Feature Selection

    Click Next to continue

    ![Feature Selection](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/PerfDash Feature.png)

  6. Setup is ready to install

    Click Install to continue

    ![Ready to Install](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/PerfDash Ready.png)

  7. The install has completed successfully

    Click Finish to end

    ![Complete](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/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) as described below:

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

    ![Copy Reports](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/PerfDash Copy.png)

  2. 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

  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

    ![Instance Setup](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/PerformanceDashboard/PerfDash Setup.png)

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

Previous Install Master Data Services Top Install System Views Map Next