SQL Nexus

 

I blogged some time ago about PAL (Performance Analysis of Logs (PAL) Tool), a great tool from CodePlex which allows you to quickly and automatically analyze  a set of Performance Monitor logs and to easily spot which counters are "misbehaving" in your environment.

 

This week I want to post about another useful tool, SQL Nexus, always downloadable from CodePlex, which instead makes it easier to analyze data collected from:

 

  • SQLDiag and
  • PSSDiag

 

How does in work

 

  1. You need SQL 2005 in order to run the tool (it will import your data in a user database called - without surprise - sqlnexus)

 

  1. Feed the tool with the data you want to analyze (SQL Trace files; T-SQL script output, including SQL DMV queries; and Performance Monitor logs)

 

  1. Once the data is loaded, you can fire up several different charts and reports to analyze it:

 

  • Blocking and wait statistics
  • Bottleneck Analysis
  • Profiler Trace Analysis

 

The latest version can be found on the official page: https://www.codeplex.com/sqlnexus

 

More information can be found in Ken Henderson's Blog: https://blogs.msdn.com/khen1234/archive/2007/09/23/random-thoughts-on-my-trip-to-the-conference.aspx

 

 

- Beatrice Nicolini -