Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

sys.dm_xe_session_event_actions (Transact-SQL)

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.

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.

Requires VIEW SERVER 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

Updated content

Updated "Relationship Cardinalities" table with the correct dynamic management view names and column names.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.