SQL SERVER – Download PSSDIAG Data Collection Utility

During an early career of mine as a database consultant – when I was dealing with SQL Server 2000, I often needed to collect various data related to SQL Server. My favorite tool to collect the data is PSSDIAG tool. It is a general purpose diagnostic collection utility that Microsoft Product Support Services uses to collect various logs and data files. It collects Performance Monitor logs, SQL Profiler traces, SQL Server blocking script output, Windows Event Logs, and SQLDIAG output. The data collected can be used by SQL Nexus tool which help you troubleshoot SQL Server performance problems. PSSDIAG is a wrapper around other data collection APIs and utilities, the performance impact of running PSSDIAG is generally equal to the impact of the traces that PSSDIAG has been configured to capture.

If you are using SQL Server 2000 – you need to seriously consider to upgrading it to SQL Server 2012.

Here is a PSSDIAG Data Collection Utility updated in August 2012. My friend and SQL Server Expert Amit Benerjee have written an excellent article on this subject, I encourage all of you to read the same.

Note: For SQL Server 2012 there is SQLDiag.

Reference: Pinal Dave (http://blog.sqlauthority.com)

7 thoughts on “SQL SERVER – Download PSSDIAG Data Collection Utility

  1. Pinal.

    That’s a pretty old link just that it was updated today. That PSSDiag is for SQL 2000 or 7.0. Refer to http://support.microsoft.com/kb/830232 which redirects to the same link you mentioned above.

    For SQL 2005+, jackli released PSSDiag last year on codeplex. Can be downloaded from http://diagmanager.codeplex.com/releases/view/67449

    More details on that release http://blogs.msdn.com/b/psssql/archive/2011/05/24/pssdiag-sqldiag-configuration-manager-released-to-codeplex.aspx

    That said, running PSSDiag may not always be a easy on Prod servers. You know the gotchas – approvals, firewalls etc..

    I, instead, encourage to use already inbuilt tool called sqldiag. There is a GUI version of it so that you configure easily. http://sdct.codeplex.com/

    P.S: Any discussion on PSSDiag would seem incomplete without a mention of its co-author Amit Banerjee. Check out his cool tips http://troubleshootingsql.com/2011/05/25/tools-tips-and-tricks-9-pssdiag-configuration-manager/

    Like

  2. Got a customer that I tried to run this on. They had installed it remotely on a server, and installed the service, but it would start and stop almost immediately. Why is it doing this?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s