SQL Nexus 6.0 is released to github

Published Jan 15 2019 05:33 PM 1,136 Views
Microsoft
First published on MSDN on Jul 26, 2017

With codeplex shutting down, we have moved SQL Nexus to github with a new release (6.0).   Now both Pssdiag/SQLDiag manager and SQL Nexus are on github.


Where to get it


As you navigate to SQL Nexus , you can download code and released binary files.

If you choose to download binary files, you can go to releases and download the zip file.




Feature improvement and bug fixes

Complete release notes is at https://github.com/Microsoft/SqlNexus/wiki/SQL-Nexus-6.0.0.8-Release-notes

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)


Reporting issues

You can also report issues and do pull requests directly from the website.  We will monitor issues.  If you do a pull request, we will review and decide to merge




Jack Li |Senior Escalation Engineer | Microsoft SQL Server

twitter | pssdiag | Sql Nexus

%3CLINGO-SUB%20id%3D%22lingo-sub-318979%22%20slang%3D%22en-US%22%3ESQL%20Nexus%206.0%20is%20released%20to%20github%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-318979%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Jul%2026%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EWith%20codeplex%20shutting%20down%2C%20we%20have%20moved%20SQL%20Nexus%20to%20github%20with%20a%20new%20release%20(6.0).%26nbsp%3B%26nbsp%3B%20Now%20both%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2FDiagManager%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Pssdiag%2FSQLDiag%20manager%20%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2FSqlNexus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20SQL%20Nexus%20%3C%2FA%3E%20are%20on%20github.%3C%2FP%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CH2%20id%3D%22toc-hId-1703718244%22%20id%3D%22toc-hId-1761987545%22%3EWhere%20to%20get%20it%3C%2FH2%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3EAs%20you%20navigate%20to%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2FSqlNexus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20SQL%20Nexus%20%3C%2FA%3E%20%2C%20you%20can%20download%20code%20and%20released%20binary%20files.%3C%2FP%3E%0A%20%20%3CP%3EIf%20you%20choose%20to%20download%20binary%20files%2C%20you%20can%20go%20to%20releases%20and%20download%20the%20zip%20file.%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68572iAA14F1574141D826%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68573i65E4B7707907D275%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CH2%20id%3D%22toc-hId--848438717%22%20id%3D%22toc-hId--790169416%22%3EFeature%20improvement%20and%20bug%20fixes%3C%2FH2%3E%0A%20%20%3CP%3EComplete%20release%20notes%20is%20at%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2FSqlNexus%2Fwiki%2FSQL-Nexus-6.0.0.8-Release-notes%22%20title%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2FSqlNexus%2Fwiki%2FSQL-Nexus-6.0.0.8-Release-notes%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fgithub.com%2FMicrosoft%2FSqlNexus%2Fwiki%2FSQL-Nexus-6.0.0.8-Release-notes%3C%2FA%3E%3C%2FP%3EMajor%20rules%20added%3COL%3E%0A%20%20%20%3CLI%3Ewarn%20if%20change%20table%20is%20used%20because%20it%20can%20cause%20high%20cpu%20%3CBR%20%2F%3E%3C%2FLI%3E%0A%20%20%20%3CLI%3Ewarn%20if%20%E2%80%9Caccess%20check%E2%80%9D%20configuration%20is%20not%20set%20correctly%20because%20it%20can%20cause%20high%20CPU%20%3CBR%20%2F%3E%3C%2FLI%3E%0A%20%20%20%3CLI%3Ewarn%20if%20attention%20occurs%20and%20involves%20in%20blocking%20%3CBR%20%2F%3E%3C%2FLI%3E%0A%20%20%20%3CLI%3Ewarn%20if%20there%20are%20major%20gaps%20detected%20in%20perf%20stats%20script%20run%20%3CBR%20%2F%3E%3C%2FLI%3E%0A%20%20%20%3CLI%3Ewarn%20presence%20of%20TF%201222%3C%2FLI%3E%0A%20%20%3C%2FOL%3EMajor%20fixes%3COL%3E%0A%20%20%20%3CLI%3Enot%20all%20trace%20flags%20apply%20to%20aall%20versions.%20This%20fix%20will%20raise%20warning%20based%20on%20version%20%3CBR%20%2F%3E%3C%2FLI%3E%0A%20%20%20%3CLI%3Eremoved%20limit%20report%20times%20out%20at%2060%20seconds%20%3CBR%20%2F%3E%3C%2FLI%3E%0A%20%20%20%3CLI%3Echange%20nexus%20DB%20recovery%20to%20simple%20%3CBR%20%2F%3E%3C%2FLI%3E%0A%20%20%20%3CLI%3Eprovides%20warning%20if%20you%20have%20both%20.xel%20and%20.trc%20files%20captured%20(import%20will%20fail)%3C%2FLI%3E%0A%20%20%3C%2FOL%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CH2%20id%3D%22toc-hId-894371618%22%20id%3D%22toc-hId-952640919%22%3EReporting%20issues%3C%2FH2%3E%0A%20%20%3CP%3EYou%20can%20also%20report%20issues%20and%20do%20pull%20requests%20directly%20from%20the%20website.%26nbsp%3B%20We%20will%20monitor%20issues.%26nbsp%3B%20If%20you%20do%20a%20pull%20request%2C%20we%20will%20review%20and%20decide%20to%20merge%3C%2FP%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68574iD68C399004BFA6E2%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3EJack%20Li%20%7CSenior%20Escalation%20Engineer%20%7C%20Microsoft%20SQL%20Server%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fjackli8898%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Etwitter%20%3C%2FA%3E%20%7C%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2FDiagManager%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20pssdiag%20%3C%2FA%3E%20%7C%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2FSqlNexus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Sql%20Nexus%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-318979%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jul%2026%2C%202017%20With%20codeplex%20shutting%20down%2C%20we%20have%20moved%20SQL%20Nexus%20to%20github%20with%20a%20new%20release%20(6.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-318979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EUtilities%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 05:33 PM
Updated by: