Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to:
SQL Server
Azure 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. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Relationship cardinalities
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 |
Next steps
Learn more about related concepts in the following articles: