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

Creating a Stored Procedure in MS SQL

Getting Character Count in MS SQL

What is Resource Governor in SQL Server ?

Changing MS SQL Database Name with Query

What is Failover Clustering in SQL Server ?