Skip to content

sys-database-event-session-actions-azure-sql-database.md

Latest commit

 

History

History
49 lines (39 loc) · 2.98 KB

sys-database-event-session-actions-azure-sql-database.md

File metadata and controls

49 lines (39 loc) · 2.98 KB
title sys.database_event_session_actions
description The sys.database_event_session_actions dynamic management view (DMV) returns a row for each action on each event of a database-scoped event session.
author rwestMSFT
ms.author randolphwest
ms.date 07/29/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
ms.custom
ignite-2025
dev_langs
TSQL
monikerRange =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

sys.database_event_session_actions

[!INCLUDE sqlserver2016-asdb-asdbmi-fabricsqldb]

The sys.database_event_session_actions dynamic management view (DMV) returns a row for each action on each event of a database-scoped event session. For information on actions in active database-scoped event sessions, see sys.dm_xe_database_session_event_actions.

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

Requires the VIEW DATABASE PERFORMANCE STATE permission.

Remarks

This view has the following relationship cardinalities.

From To Relationship
sys.database_event_session_actions.event_session_id sys.database_event_sessions.event_session_id Many to one
sys.database_event_session_actions.event_id

sys.database_event_session_actions.event_session_id		 sys.database_event_session_events.event_session_id

sys.database_event_session_events.event_id		 Many to one

Related content