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.

See Also

Concepts

Designing Event Notifications

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
14 April 2006	Changed content: Updated tree diagram.