Trace Event Groups for Use with Event Notifications

The following diagram lists the SQL Trace event groups that can be used to run an event notification and the Transact-SQL statements they cover. Note the inclusive nature of the event groups, as indicated by the tree structure of the diagrams. For example, an event notification that specifies FOR TRC_LOCKS covers the LOCK_DEADLOCK, LOCK_DEADLOCK_CHAIN, LOCK_ESCALATION, and DEADLOCK_GRAPH events.

These groups can be run only at the server instance level.

Trace events and event groups

See Also


Designing Event Notifications

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006

Changed content:
  • Updated tree diagram.