sys.dm_xe_session_events (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

Returns information about session events. Events are discrete execution points. Predicates can be applied to events to stop them from firing if the event does not contain the required information.

Column name Data type Description
event_session_address varbinary(8) The memory address of the event session. Is not nullable.
event_name nvarchar(256) The name of the event that an action is bound to. Is not nullable.
event_package_guid uniqueidentifier The GUID for the package containing the event. Is not nullable.
event_predicate nvarchar(3072) An XML representation of the predicate tree that is applied to the event. Is nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

From To Relationship
sys.dm_xe_session_events.event_session_address sys.dm_xe_sessions.address Many-to-one
sys.dm_xe_session_events.event_package_guid,

sys.dm_xe_session_events.event_name
sys.dm_xe_objects.name,

sys.dm_xe_objects.package_guid
Many-to-one

See Also

Dynamic Management Views and Functions (Transact-SQL)