Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.dm_xe_session_events (Transact-SQL)

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(60)

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(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

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

Updated content

Corrected the data type for the event_predicate column.

Corrected the description for the event_predicate column to indicate that the value is nullable.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.