Systems Engineering and RDBMS

PSSDiag and SQLDiag

Posted by decipherinfosys on September 11, 2007

In late 2004, Microsoft Product Support Services (PSS) team made three very useful tools available to the public. The tools are PSSDiag, Ostress and Read80trace.  We will cover more on the Ostress and the Read80Trace in future blog posts as we demonstrate their usage in benchmark environments.  These tools can save database folks a lot of time in collecting and analyzing the data for troubleshooting a problem or simply for benchmarking purpose.

If you are using SQL Server 7.0 or 2000, you can use the PSSDiag utility and can download it from here:;en-us;830232

If you are using SQL Server 2005, this is re-named as SQLDiag and is present with the main SQL Server 2005 install. You can get more information on it from BOL (Books Online). Here is the help output from my instance:

H:\>sqldiag /?

SQLDiag collector version 2005.090.3042.00

c Microsoft Corp. All rights reserved.

Usage: sqldiag [START | STOP | STOP_ABORT] [/O outputpath] [/I cfgfile] [/M machine|@machinelistfile] [/Q] [/C #] [/G] [/R] [/U] [/N #] [/A appname] [/X] [/L] [/B YYYYMMDD_HH:MM:SS] [/E YYYYMMDD_HH:MM:SS]

One Response to “PSSDiag and SQLDiag”

  1. […] We had briefly touched upon the usage of SQLDiag in some of our previous posts including the one here. While working on a client issue this weekend, it was surprising to see that none of the client […]

Sorry, the comment form is closed at this time.

%d bloggers like this: