SQL Nexus 6.0.0.8 is the first release on GitHub. This will be our new release platform. Please stop using codeplex version.

Development Environment

1. Visual Studio 2017
2. Report Builder 2016

Requirements to run the tool

1. .NET framework 4.6.2 (https://www.microsoft.com/en-us/download/details.aspx?id=53344). Windows 10 anniversary update has version already.
2. One of the following on the machine where you will run the tool:
   a. SQL Server 2016
   b. SQL Server 2016 feature components (https://www.microsoft.com/en-us/download/details.aspx?id=52676)
   i. Download and install enu\x86\sqlsysclrtypes.msi
   ii. Download and install enu\x86\reportviewer.msi
3. An instance of SQL Server (2012 or above) to be connected by this tool to process data

Improvements and fixes

Major rules added

1. warn if change table is used because it can cause high cpu
2. warn if “access check” configuration is not set correctly because it can cause high CPU
3. warn if attention occurs and involves in blocking
4. warn if there are major gaps detected in perf stats script run
5. warn presence of TF 1222

Major fixes

1. not all trace flags apply to aall versions. This fix will raise warning based on version
2. removed limit report times out at 60 seconds
3. change nexus DB recovery to simple
4. provides warning if you have both .xel and .trc files captured (import will fail)

Download

Binary SQLNexus.6.0.0.8.zip