SQL Server - Use The SQLDIAG Utility For a Snapshot Of Your SQL Server's Health (SQL Server 7.0/2000)

An often overlooked command-line utility that comes with SQL Server, SQLDIAG, can help you to troubleshoot problems or just keep an eye on your server's health. It gathers error log information, registry settings, lock information, details about running processes and extended stored procedures, input buffers, head blockers, and much more.

It lives in the ...MSSQLBinn folder. You can invoke it with a number of command-line options (see Books Online for details). But at a minimum, you'll generally pass the -U and -P switches, which allow you to specify the User ID and Password to connect with, respectively.

Go back