SQLdiag utility is a general purpose diagnostics collection utility that can be run as a console application or as a service. You can use SQLdiag to collect logs and data files from SQL Server and other types of servers, and use it to monitor your servers over time or troubleshoot specific problems with your servers. SQLdiag is intended to expedite and simplify diagnostic information gathering for Microsoft Customer Support Services.

SQLdiag can collect the following types of diagnostic information: 

• Windows performance logs

• Windows event logs 

• SQL Server Profiler traces

• SQL Server blocking information

• SQL Server configuration information