To help troubleshoot intermittent database errors, especially random “lock-ups” or slowdowns, you can use the SQL Snapshot Utility. The SQL Snapshot Utility can take a snapshot of all database activity to identify the SQL statements that occurred at a given time. You can take snapshots of the server at set intervals, keep a rolling logfile, filter the captured activity, and save or export snapshots.
The SQL Snapshot Utility uses Windows Management Instrumentation (WMI) extensions to gather and provide information and notification about your server.