- Install SQL Nexus
- Collect perf data from your SQL Server 2005 instance using SQLDiag
- Import and analyze the data using SQL Nexus
- following the Installation Steps carefully as it requires certain components
In order to use SQL Nexus, first you will need data collected. SQL Nexus relies on sqldiag.exe collector engine to collect data. But it needs to collect various DMV outputs and specific profiler trace events for the reports to work.
With release of pssdiag/sqldiag manager
to codeplex, you have two choices to do data collection.
Method 1 (recommended): Please download pssdiag/sqldiag manager
and configuration data collection package to collect data.
Method 2: you can continue to use old method to use bach files provided. collecting data using batch files
. But with release of pssdiag/sqldiag manager
, we don't intend maintain these batch files.
- Launch sqlnexus.exe and log on to the non-production SQL Server instance where you installed SQL Nexus.
- Click on "Import" in the left pane of the main SQL Nexus window.
- Provide the file directory where you stored the data collected by SQLDiag. Note: you should provide a directory path, not a file name.
- Once the import is finished, you can click on various reports from the left pane of SQL Nexus tool. Start with the "Bottleneck Analysis" report to determine where most query execution time was spent
Here is a quick walkthrough on how to use SQL Nexus to analyze diagnostic data collected using SQL Diag and PSSDIAG: http://zeollar.cloudapp.net/Session/144