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:
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:
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”
Sorry, the comment form is closed at this time.