| title | sys.dm_xe_session_event_actions (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_xe_session_event_actions (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 3/30/2022 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| ms.assetid | 0c22a546-683e-4c84-ab97-1e9e95304b03 |
[!INCLUDE SQL Server SQL Managed Instance]
Returns information about event session actions for active server-scoped sessions. Actions are executed when events are fired.
Azure SQL Database supports only database-scoped sessions. See sys.dm_xe_database_session_event_actions.
| Column name | Data type | Description |
|---|---|---|
| event_session_address | varbinary(8) | The memory address of the event session. Is not nullable. |
| action_name | nvarchar(256) | The name of the action. Is not nullable. |
| action_package_guid | uniqueidentifier | The GUID for the package that contains the action. Is not nullable. |
| event_name | nvarchar(256) | The name of the event that the action is bound to. Is not nullable. |
| event_package_guid | uniqueidentifier | The GUID for the package that contains the event. Is not nullable. |
Requires VIEW SERVER STATE permission on the server.
| From | To | Relationship |
|---|---|---|
| sys.dm_xe_session_event_actions.event_session_address | sys.dm_xe_sessions.address | Many-to-one |
| sys.dm_xe_session_event_actions.action_name, sys.dm_xe_session_event_actions.action_package_guid |
sys.dm_xe_objects.name, sys.dm_xe_session_events.event_package_guid |
Many-to-one |
| sys.dm_xe_session_event_actions.event_name, sys.dm_xe_session_event_actions.event_package_guid |
sys.dm_xe_objects.name, sys.dm_xe_objects.package_guid |
Many-to-one |
Learn more about related concepts in the following articles: