SQL Nexus

 

SQL Nexus is an extensible diagnostics collection, reporting, charting, and analysis tool.  It automates both the collection and analysis of diagnostic data, particularly that related to SQL Server.

 

SQL Nexus allows you to view critical SQL Server performance and diagnostic info in easy-to-read charts and reports.  You can drill through from one report to another and can even export or email reports and charts.

 

SQL Nexus uses the SQL Server database engine to collect and aggregate diagnostic information.  In its current incarnation, this data relates to SQL Server itself, particularly the performance of SQL Server.  A primary use of this version of SQL Nexus is to diagnose and troubleshoot SQL Server performance issues.

 

SQL Nexus uses SQL Server Reporting Services technology to generate reports and charts based on the diagnostic data it collects.  This means that you can customize the reports and charts that ship with SQL Nexus or create your own using both SQL Server Reporting Services and Visual Studio.

 

SQL Nexus installs via ClickOnce technology and will automatically check for updates when you run it. To install it, click here.  

 

To start SQL Nexus, click the SQL Nexus icon in the Windows Start menu.  SQL Nexus can run as either a console app or a Windows GUI app.  Pass /? on the command line to list the parameters it supports.

 

SQL Nexus includes online help, and you can learn more about SQL Nexus at http://www.khen.com/sqlnexus.htm.