Diag Manager Release

Rating:        Based on 2 ratings
Reviewed:  2 reviews
Downloads: 16064
Change Set: 61074
Released: Jun 1, 2011
Updated: Jun 1, 2011 by jackli
Dev status: Stable Help Icon

Recommended Download

Application setup.
application, 1200K, uploaded Jun 1, 2011 - 16064 downloads

Release Notes

This release fixed a bug regarding saving the final package. If you browse a folder when saving the configured package, the default file name will change back to pssd.exe. It should be pssd.cab.

Reviews for this release

The app is 32-bit and can be installed on a 64-bit version of Windows. What is important is that this app will create a coordinated, templated, and automated data collection process. It is packaged into a cab file (that should be extracted into a folder upon a x86 or x64 SQL Server). Without this app, a good data collection for requires perfmon logs, repeated polls of various DMVs (dm_exec_requests, etc) and traces, all collected at the same time. In other words, unless you a juggler, this app will save you a lot of "Nope. We didn't get X. Try again." This does not mean this app _always_ gets you _all_ the needed data, but it is still far better than any manual effort you might be able to concoct. The data you configure in pssdiag manager (use the detailed template, if your SQL Server has the disk throughput to handle it) and the data pssdiag collects can be imported into SQL Nexus (on codeplex). Both SQL Nexus/pssdiag were written by Microsoft Escalation Engineers, which means the collected data, and the analysis of it, is being presented in a format useful for those who handle the most performance problems in this world. Become proficient with it: You will see the light
by HotRats on Jul 3, 2014 at 4:02 PM
Do not know whether 64 bit is able to use this program or not.
by calvinjohn on Jun 28, 2012 at 5:40 PM