Skip to content

Latest commit

 

History

History
56 lines (44 loc) · 2.41 KB

File metadata and controls

56 lines (44 loc) · 2.41 KB
title sys.server_event_session_actions (Transact-SQL)
description The sys.server_event_session_actions catalog view returns a row for each action on each event of an event session.
author rwestMSFT
ms.author randolphwest
ms.date 09/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sys.server_event_session_actions
server_event_session_actions_TSQL
server_event_session_actions
sys.server_event_session_actions_TSQL
helpviewer_keywords
sys.server_event_session_actions catalog view
xe
dev_langs
TSQL
monikerRange >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

sys.server_event_session_actions (Transact-SQL)

[!INCLUDE sqlserver-asdbmi]

Returns a row for each action on each event of 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 the event session object. Is not nullable.
name sysname The name of the action. Is nullable.
package sysname The name of the event package that contains the event. Is nullable.
module sysname The name of the module that contains the event. Is 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.event_session_id
sys.server_event_session_events.event_session_id

sys.server_event_session_events.event_id
Many to one

Related content