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
In your experience – have you used SQLdiag for benchmarking , such as :
http://www.sqlserver-dba.com/2011/06/window-perfmon-scripting-sql-server-perfmon-and-how-to-perfmon.html
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.