A lot of you are probably familiar with pssdiag tool released for SQL Server 7.0 and 2000 and sqldiag.exe utility shipped with SQL Server 2005, 2008 and 2008 R2. These are data collection diagnostics tools that allow collecting data such as profiler trace, perfmon and DMV information.
For sqldiag.exe shipped with SQL Server 2005 and beyond, there isn’t a configuration tool publically available that allows customization. Microsoft product support has maintained a separate configuration tool that would allow support engineers to customize and collect data for troubleshooting SQL Server issues.
Due to customers’ demand, we have just released this configuration tool under codeplex. The URL is at http://diagmanager.codeplex.com/.
You can use this configuration manager to customize what data you need to collect. Additionally, you can use Pssdiag/Sqldiag Configuration Manager to collect data for SQL Nexus which is a data analysis tool used by Microsoft product support.
The project has source code that allows you to further enhance the tool. But it also includes download of compiled binary. You don’t have to manually build the project in order to use it. Just download the setup program and run it on your machine.
Learning curve should be very low. If all you need is to collect data for SQL Nexus, you just need to choose versions and platforms. The default data collections (perfmon counters, trace events and DMV data collection) are selected for you. The project page has detailed steps on configuring and running for data collection.
Please use discussion and issue tracker tabs to ask questions or report issues. Below is a screenshot of the main page.
Jack Li | Senior Escalation Engineer|Microsoft SQL Server Support