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

What is FILLFACTOR in SQL Server ?

How is Deadlock Different From a Blocking Situation in SQL Server ...

What is the Filtered Index in SQL Server ?

Benefits of Using Stored Procedures in MS SQL

What is a Control Flow Inside SSIS ?