sys.server_event_session_actions (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

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

SQL Server 2019 (15.x) and previous versions require VIEW SERVER STATE permission on the server.

SQL Server 2022 (16.x) 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

• System catalog views (Transact-SQL)
• Extended Events Catalog Views (Transact-SQL)
• Extended Events overview