sqldiag Utility

The sqldiag utility gathers and stores diagnostic information and the contents of the query history trace (if running) into \Mssql7\Log\Sqldiag.txt and Mssql7\Log\Sqldiag.trc This output file includes error logs, output from sp_configure and additional version information. If the query history trace was running when the utility was invoked, the trace file will contain the last 100 SQL events and exceptions. sqldiag is intended to expedite and simplify information gathering by Microsoft Product Support Services.

Syntax

sqldiag [ [-U login_ID] [-P password] | [-E] ] [-O output_file]

Arguments

-U login_ID

Is the user login ID. Login IDs are case-sensitive.

-P password

Is the password for the specified login_ID. If the -P option is specified at the end of the command prompt specifying password, sqldiag uses the default without password of NULL. Passwords are case-sensitive.

-E

Uses a trusted connection instead of requesting a password. For use with Microsoft® Windows NT® only.

-O output_file

Is the file receiving the sqldiag output (text and trace files). If this option is not specified, Microsoft SQL Server™ uses the default output file name of Sqldiag.txt and Sqldiag.trc.

Remarks

The sqldiag utility can be run anytime, whether or not SQL Server is started. If SQL Server is running, sqldiag gathers these items:

• Text of all error logs.
• Registry information.
• dll version information.
• Output from:
  • sp_configure
  • sp_who
  • sp_lock
  • sp_helpdb
  • xp_msver
  • sp_helpextendedproc
  • sysprocesses
• Input buffer SPIDs/deadlock information.
• Microsoft Diagnostics Report for the server, including:
  • Contents of <servername>.txt file.
  • Operating System Version Report
  • System Report
  • Processor List
  • Video Display Report
  • Hard Drive Report
  • Memory Report
  • Services Report
  • Drivers Report
  • IRQ and Port Report
  • DMA and Memory Report
  • Environment Report
  • Network Report
• The last 100 queries and exceptions.

If SQL Server is not running, sqldiag skips gathering the input buffer SPIDs information and the diagnostics report. sqldiag must be run on the server itself, not on a client workstation. If sqldiag is executed on a Microsoft Windows® 95/98 server, the -U and -P options are required, which means sqldiag must be run from an MS-DOS® window. The information gathered by sqldiag for a Windows 95/98 server will be less complete than the information gathered on a Windows NT Server.

See Also