sys-dm-xe-session-events-transact-sql.md

title	sys.dm_xe_session_events (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	dmv's
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.dm_xe_session_events sys.dm_xe_session_events_TSQL dm_xe_session_events dm_xe_session_events_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.dm_xe_session_events dynamic management view extended events [SQL Server], views
ms.assetid	4f027b31-4e03-43a6-849d-1ba9d8d34ae8
caps.latest.revision	17
author	stevestein
ms.author	sstein
manager	craigg

sys.dm_xe_session_events (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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.

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)