sys.dm_xe_session_events (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 nameData typeDescription
event_session_addressvarbinary(8)The memory address of the event session. Is not nullable.
event_namenvarchar(60)The name of the event that an action is bound to. Is not nullable.
event_package_guiduniqueidentifierThe GUID for the package containing the event. Is not nullable.
event_predicatenvarchar(2048)An XML representation of the predicate tree that is applied to the event. Is nullable.

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

FromToRelationship
sys.dm_xe_session_events.event_session_addresssys.dm_xe_sessions.addressMany-to-one
sys.dm_xe_session_events.event_package_guid, sys.dm_xe_session_events.event_namesys.dm_xe_objects.name, sys.dm_xe_objects.package_guidMany-to-one

Dynamic Management Views and Functions (Transact-SQL)

Community Additions

ADD
Show: