Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_xe_session_events (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Applies to: SQL Server (SQL Server 2008 through current version).

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

Community Additions

ADD
Show:
© 2015 Microsoft