Install SQL Nexus - SQL-FineBuild/Common GitHub Wiki

Previous Install RML Utilities Manual Install Install Troubleshooting Guide Next

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

SQL Nexus is written by Ken Henderson and Bart Duncan et al at Microsoft. It was chosen to be included in FineBuild because it helps identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag (for SQL 2005 and above) and PSSDiag (for SQL 2000), and can dramatically reduce the amount of time spent manually analyzing data.

If you install SQL Nexus, you must also Install .Net 4 and Install Report Viewer.

Item Location
SQL Nexus home page https://github.com/microsoft/SqlNexus/wiki
SQL Nexus download SQL2008 and above see Download for SQL 2008 and Above
SQL2005 only see Download for SQL 2005
SQL Nexus tutorial https://www.mssqltips.com/sqlservertip/1899/tool-to-help-you-analyze-sql-server-sqldiag-and-pssdiag-output/
SQLDiag Tutorial https://github.com/microsoft/diagmanager/wiki

Download for SQL 2008 and Above

Download the latest version of SQL Nexus from https://github.com/microsoft/SqlNexus/releases

Download for SQL 2005

  1. Download SQL Nexus from https://web.archive.org/web/20210201143117/https://codeplexarchive.blob.core.windows.net/archive/projects/sqlnexus/sqlnexus.zip

  2. Navigate to the SQLNexus.zip\Releases\3 folder

  3. Copy the file bbd0adce-97ea-403a-9a85-8e9f3faa5575 to the \Additional Components folder

  4. Rename the bbd0adce-97ea-403a-9a85-8e9f3faa5575 file to SQLNexus3.0.0.0.zip

FineBuild SQL Nexus Install

Automated silent installation of SQL Nexus is performed by Process Id 4TG and is controlled by the parameters below:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupSQLNexus: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2017 /SetupSQLNexus: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2016 /SetupSQLNexus: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2014 /SetupSQLNexus: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2012 /SetupSQLNexus: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2008R2 /SetupSQLNexus: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2008 /SetupSQLNexus: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2005 /SetupSQLNexus: Yes Yes Yes
/SetupSQLTools: No Yes Yes

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

SQL FineBuild also uses the following parameters to help install SQL Nexus:

Parameter Default Value Description
/SQLNexuszip: SQLNexus3.0.0.0.zip Name of SQL Nexus install media for SQL2005
/SQLNexuszip: SQLNexus6.0.0.8.zip Name of SQL Nexus install media for all other SQL versions.

SQL Nexus 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 FineBuild install for SQL Nexus includes the following:

Top

Manual SQL Nexus Install

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

Install SQL Nexus

  1. Navigate to the Additional Components folder

    Double-click on the SQL Nexus .zip folder

    ![Explorer](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ToolsExtras/SQLNexus/SQL Nexus Explorer zip.png)

  2. Extract all files to E:\Program files\Microsoft SQL Server \SQL Nexus

    ![Extract](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ToolsExtras/SQLNexus/SQL Nexus Explorer Extract.png)

Setup SQL Nexus Menu Item

  1. Navigate to E:\Program Files\Microsoft SQL Server\SQL Nexus

    Right-click on sqlnexus.exe and select Copy

    ![Menu Copy](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ToolsExtras/SQLNexus/SQL Nexus Explorer Menu Copy.png)

  2. Navigate to the SQL Server Performance Tools menu folder on C:

    Select Paste Shortcut

    ![Menu Paste](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ToolsExtras/SQLNexus/SQL Nexus Explorer Menu Paste.png)

  3. Right-click on the menu shortcut

    Rename it to SQL Nexus

    ![Menu Rename](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ToolsExtras/SQLNexus/SQL Nexus Explorer Menu Rename.png)

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

Previous Install RML Utilities Top Install Troubleshooting Guide Next