Skip to content

Latest commit

 

History

History
51 lines (43 loc) · 2.1 KB

sys-server-event-session-events-transact-sql.md

File metadata and controls

51 lines (43 loc) · 2.1 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.server_event_session_events (Transact-SQL)
sys.server_event_session_events (Transact-SQL)
rwestMSFT
randolphwest
03/14/2017
sql
system-objects
reference
server_event_session_events
server_event_session_events_TSQL
sys.server_event_session_events
sys.server_event_session_events_TSQL
sys.server_event_session_events catalog view
xe
TSQL

sys.server_event_session_events (Transact-SQL)

[!INCLUDE sqlserver-asdbmi]

Returns a row for each event in an event session.

Column name Data type Description
event_session_id int The ID of the event session. Is not nullable.
event_id int The ID of the event. This ID is unique within an event session object. Is not nullable.
name sysname The name of the event. Is not nullable.
package sysname The name of the event package that contains the event. Is not nullable.
module sysname The name of the module that contains the event. Is not nullable.
predicate nvarchar(3000) The predicate expression that is applied to the event. Is nullable.
predicate_xml nvarchar(3000) The XML predicate expression that is applied to the event. Is nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

Remarks

This view has the following relationship cardinalities.

From To Relationship
sys.server_event_session_events.event_session_id sys.server_event_sessions.event_session_id Many to one

See Also

Catalog Views (Transact-SQL)
Extended Events Catalog Views (Transact-SQL)
Extended Events