When Will You Use SQLDiag Tool ?
The SQLdiag utility is a general-purpose diagnostics collection utility that can be run as a console application or as a service and can be very useful for Performance tuning exercises. SQLdiag is fully configurable through the SQLdiag.xml configuration file and can collect a variety of diagnostic information like Windows performance logs, Windows event logs, SQL Server Profiler traces, SQL Server blocking information and SQL Server configuration information.