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

Getting List of All Views in MS SQL Database

What are The Different Backup Options With SQL Server ?

What is Change Data Capture in SQL Server ?

What are Indexed Views inside SQL Server ?

What is Extensible Key Management in SQL Server ?