Install SQL Nexus
| 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 the latest version of SQL Nexus from https://github.com/microsoft/SqlNexus/releases
-
Download SQL Nexus from https://web.archive.org/web/20210201143117/https://codeplexarchive.blob.core.windows.net/archive/projects/sqlnexus/sqlnexus.zip
-
Navigate to the SQLNexus.zip\Releases\3 folder
-
Copy the file bbd0adce-97ea-403a-9a85-8e9f3faa5575 to the \Additional Components folder
-
Rename the bbd0adce-97ea-403a-9a85-8e9f3faa5575 file to SQLNexus3.0.0.0.zip
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:
The following steps show what you would have to do to install SQL Nexus manually. FineBuild does all of this work for you automatically.
-
Navigate to the Additional Components folder
Double-click on the SQL Nexus .zip folder
-
Extract all files to E:\Program files\Microsoft SQL Server \SQL Nexus
-
Navigate to E:\Program Files\Microsoft SQL Server\SQL Nexus
Right-click on sqlnexus.exe and select Copy
-
Navigate to the SQL Server Performance Tools menu folder on C:
Select Paste Shortcut
-
Right-click on the menu shortcut
Rename it to SQL Nexus
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
| Previous Install RML Utilities | Top | Install Troubleshooting Guide Next |
|---|