Configuration Manager for Sqldiag

SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor your servers over time or troubleshoot specific problems with your servers.  SQLdiag can collect data from: Windows performance logs, Windows event logs, SQL Server Profiler traces, SQL Server blocking information, and SQL Server configuration information.

Until now, there was not a way to customize what data you needed to collect.  But Microsoft has released a tool to allow customization, called Pssdiag and Sqldiag Manager (Pssdiag is the version for SQL Server 7.0/2000).  Additionally, you can use it to collect data for SQL Nexus, which is a data analysis tool used by Microsoft product support (SQL Nexus helps you identify the root cause of SQL Server performance issues – it loads and analyzes performance data collected by SQLdiag).

More info on Pssdiag Manager: Pssdiag/Sqldiag Configuration Manager released to codeplex

More info on SQLDiag: How to use SQLDiag, SQLNexus and PAL tools to analyze performance issues in SQL Server

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQL Server, SQLServerPedia Syndication. Bookmark the permalink.

2 Responses to Configuration Manager for Sqldiag

    • James says:

      Hi Jack,

      Nice article! I have not used SQLdiag for benchmarking, only for trying to solve a performance issue. But using the steps in your article to capture the perfmon data, then stress testing the server, and then using SQLdiag to analyze the data is a great idea. Thanks for the link.

Leave a Reply

Your email address will not be published. Required fields are marked *