Skip to content

Latest commit

 

History

History
47 lines (39 loc) · 1.94 KB

File metadata and controls

47 lines (39 loc) · 1.94 KB
title sys.dm_xe_database_session_events (Azure SQL Database) | Microsoft Docs
ms.custom
MSDN content
MSDN - SQL DB
ms.date 2016-06-10
ms.prod sql-non-specified
ms.reviewer
ms.service sql-database
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
ms.assetid 9e985a19-f93f-4c56-b644-12c529298011
caps.latest.revision 8
author MightyPen
ms.author genemi
manager jhubbard

sys.dm_xe_database_session_events (Azure SQL Database)

[!INCLUDEtsql-appliesto-xxxxxx-asdb-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.

Applies to: [!INCLUDEssSDSfull] V12 and any later versions.
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 DATABASE STATE permission.

Relationship Cardinalities

From To Relationship
sys.dm_xe_database_session_events.event_session_address sys.dm_xe_database_sessions.address Many-to-one
sys.dm_xe_database_session_events.event_package_guid, sys.dm_xe_database_session_events.event_name sys.dm_xe_objects.name, sys.dm_xe_objects.package_guid Many-to-one