sys.dm_xe_session_event_actions (Transact-SQL)

sys.dm_xe_session_event_actions (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about event session actions. 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.

Applies to: SQL Server (SQL Server 2008 through current version).
Column nameData typeDescription
event_session_addressvarbinary(8)The memory address of the event session. Is not nullable.
action_namenvarchar(60)The name of the action. Is not nullable.
action_package_guiduniqueidentifierThe GUID for the package that contains the action. Is not nullable.
event_namenvarchar(60)The name of the event that the action is bound to. Is not nullable.
event_package_guiduniqueidentifierThe GUID for the package that contains the event. Is not nullable.

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

FromToRelationship
sys.dm_xe_session_event_actions.event_session_addresssys.dm_xe_sessions.addressMany-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
Updated content
Updated "Relationship Cardinalities" table with the correct dynamic management view names and column names.

Dynamic Management Views and Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft