SQL Server – Download the Perfstats script

31 August,2012 by Tom Collins

Troubleshooting SQL Server environments , I need to gather data and troubleshoot SQL Server performance problems as time critical. One of the tools I use is the Perfstats Script. The scripts originally came from the SQK Server support group at Microsoft. One of main benefits is using this script is the templates capture data from different sources: SQL Trace, Blocking information, Event Logs, SQL Diag and Perfmon.

Download the scripts and begin to experiment. Once you’ve used them a few times and begin to understand which template to use -   focus on interpreting the data.

Step 1 – Navigate to http://www.codeplex.com/sqlnexus

Step 2-  Under the Feature highlights section ,  go to point 4. Click on : SQL 2005 Perf Stats Script or SQL 2008 Perf Stats

Step 3 -  Click Page Info on the navigation bar and go to the File Attachments section . Download the relevant version

 Once you’ve extracted the files – you’ll dicover a number files . predefined for usage with SQLDiag.exe

The standard templates deal with  - Performance Statistics, Blocking, Latch contention

 Before deciding which of the Perfstats Templates to use:

SQLDiagPerfStats_Trace.XML

SQLDiagPerfStats_Detailed_Trace.XML

SQLDiagReplay.xml

 

Consider what is the aim of gathering this data?

 Related Posts

 SQL Server Performance Killers

 SQL Server Performance ,memory pressure and memory usage

SQL Server Performance Checklist


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL Server – Download the Perfstats script


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer