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.



You May Interest

Using MS SQL If Else

General Information List of All Allowed Databases in MS SQL Serve ...

Finding List of Tables Using View in MS SQL

What are the Events On Default Trace in SQL Server ?

Changing MS SQL Table Name with Query