Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric Preview
The sys.dm_xe_database_session_event_actions dynamic management view (DMV) returns information about event session actions for active database-scoped sessions. Actions are executed when events are fired. This management view aggregates statistics about the number of times an action has run, and the total run time of the action. For information on all actions in database-scoped sessions, see sys.database_event_session_actions.
- Azure SQL Database and SQL database in Fabric support only database-scoped sessions.
- Azure SQL Managed Instance supports both database-scoped sessions and server-scoped sessions. Server-scoped sessions are recommended for SQL managed instances. For more information, see CREATE EVENT SESSION code examples.
| Column name | Data type | Description |
|---|---|---|
event_session_address |
varbinary(8) | The memory address of the event session. Is not nullable. |
action_name |
nvarchar(60) | 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(60) | 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. |
Permissions
Requires the VIEW DATABASE STATE permission.
Relationship cardinalities
| From | To | Relationship |
|---|---|---|
sys.dm_xe_database_session_event_actions.event_session_address |
sys.dm_xe_database_sessions.address |
Many-to-one |
sys.dm_xe_database_session_event_actions.action_namesys.dm_xe_session_event_actions.action_package_guid |
sys.dm_xe_objects.namesys.dm_xe_database_session_events.event_package_guid |
Many-to-one |
sys.dm_xe_database_session_event_actions.event_namesys.dm_xe_database_session_event_actions.event_package_guid |
sys.dm_xe_objects.namesys.dm_xe_objects.package_guid |
Many-to-one |
Related content
- Extended events in Azure SQL Database
- Event File target code for extended events in Azure SQL Database and SQL Managed Instance
- sys.dm_xe_database_session_targets (Azure SQL Database and Azure SQL Managed Instance)
- sys.dm_xe_database_sessions (Azure SQL Database and Azure SQL Managed Instance)
- Monitoring Microsoft Azure SQL Database and Azure SQL Managed Instance performance using dynamic management views