Επεξεργασία

Κοινή χρήση μέσω


sys.dm_xe_session_event_actions (Transact-SQL)

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: