This project has moved. For the latest updates, please go here.

Previous Install RML Utilities Manual Install Install Troubleshooting Guide Next

Install SQL Nexus

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

SQL Nexus home page http://sqlnexus.codeplex.com
SQL Nexus download http://sqlnexus.codeplex.com
SQL Nexus tutorial http://www.mssqltips.com/tip.asp?tip=1899&home

For SQL2005 you should download release 3.0.0.0 and give the download file the name SQLNexus3.0.0.0.zip.

For all other versions of SQL Server you should download release 4.0.0.64 and give the download file the name SQLNexus4.0.0.64.zip.

FineBuild SQL Nexus Install

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

If you install SQL Nexus, you must also Install Report Viewer component.

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupSQLNexus FULL Yes Yes Yes Yes Yes
SetupSQLTools No No No No No
SetupSQLNexus WORKSTATION Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes
SetupSQLNexus 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 InstSQLNexus and InstSQLTools can also be used.

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 SQLNexus4.0.0.64.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:
  • Perform a SQL Nexus install
  • Add a menu item for SQL Nexus to the Performance Tools menu.

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 and double-click on SQLNexus4.0.0.64.zip.
SQL Nexus Explorer zip.png
2) Extract all files to E:\Program files\Microsoft SQL Server \SQL Nexus.
SQL Nexus Explorer Extract.png

Setup Menu Item

1) Navigate to E:\Program Files\Microsoft SQL Server\SQL Nexus, right-click on sqlnexus.exe and select Copy.
SQL Nexus Explorer Menu Copy.png
2) Navigate to the SQL Server Performance Tools menu folder on C: and select Paste Shortcut.
SQL Nexus Explorer Menu Paste.png
3) Right-click on the menu shortcut and rename it to SQL Nexus.
SQL Nexus Explorer Menu Rename.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install RML Utilities Top Install Troubleshooting Guide Next

Last edited Oct 23, 2014 at 11:24 AM by EdVassie, version 25