SQL Nexus 6.0.0.8
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
- Visual Studio 2017
- Report Builder 2016
Requirements to run the tool
- .NET framework 4.6.2 (https://www.microsoft.com/en-us/download/details.aspx?id=53344). Windows 10 anniversary update has version already.
- 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 - An instance of SQL Server (2012 or above) to be connected by this tool to process data
Improvements and fixes
Major rules added
- warn if change table is used because it can cause high cpu
- warn if “access check” configuration is not set correctly because it can cause high CPU
- warn if attention occurs and involves in blocking
- warn if there are major gaps detected in perf stats script run
- warn presence of TF 1222
Major fixes
- not all trace flags apply to aall versions. This fix will raise warning based on version
- removed limit report times out at 60 seconds
- change nexus DB recovery to simple
- provides warning if you have both .xel and .trc files captured (import will fail)