Skip to content

Latest commit

 

History

History
55 lines (44 loc) · 2.61 KB

File metadata and controls

55 lines (44 loc) · 2.61 KB
title sys.server_event_session_fields (Transact-SQL)
description The sys.server_event_session_fields catalog view returns a row for each customizable column that was explicitly set on events and targets.
author rwestMSFT
ms.author randolphwest
ms.date 09/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
server_event_session_fields
server_event_session_fields_TSQL
sys.server_event_session_fields
sys.server_event_session_fields_TSQL
helpviewer_keywords
sys.server_event_session_fields catalog view
xe
dev_langs
TSQL
monikerRange >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

sys.server_event_session_fields (Transact-SQL)

[!INCLUDE sqlserver-asdbmi]

Returns a row for each customizable column that was explicitly set on events and targets.

Column name Data type Description
event_session_id int The ID of the event session. Is not nullable.
object_id int The ID of the object this field is associated with. Is not nullable.
name sysname The name of the field. Is not nullable.
value sql_variant The value of the field. Is not nullable.

Permissions

[!INCLUDE sssql19-md] and previous versions require VIEW SERVER STATE permission on the server.

[!INCLUDE sssql22-md] and later versions require VIEW SERVER PERFORMANCE STATE permission on the server.

Remarks

This view has the following relationship cardinalities.

From To Relationship
sys.server_event_session_actions.event_session_id sys.server_event_sessions.event_session_id Many to one
sys.server_event_session_actions.event_id

sys.server_event_session_actions.object_id

sys.server_event_session_actions.event_session_id
sys.server_event_session_events.event_session_id

sys.server_event_session_events.event_id
Many to one
sys.server_event_session_actions.event_session_id

sys.server_event_session_actions.object_id
sys.server_event_session_targets.event_session_id

sys.server_event_session_targets.target_id
Many to one

Related content