A lot of you are probably familiar with
released for SQL Server 7.0 and 2000 and
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.
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
Jack Li | Senior Escalation Engineer|Microsoft SQL Server Support