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: http://www.codeplex.com/sqlnexus


 


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


 



 


- Beatrice Nicolini -

Comments (2)

  1. Anonymous says:

    Olen avastanud enda jaoks eriti väärtusliku vahendi Live rakenduste SQL Server 2005 andmebaasiserveri

Skip to main content