sys.dm_xe_session_targets (Transact-SQL)

sys.dm_xe_session_targets (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 session targets.

Column nameData typeDescription
event_session_addressvarbinary(8)The memory address of the event session. Has a many-to-one relationship with sys.dm_xe_sessions.address. Is not nullable.
target_namenvarchar(60)The name of the target within a session. Is not nullable.
target_package_guiduniqueidentifierThe GUID of the package that contains the target. Is not nullable.
execution_countbigintThe number of times the target has been executed for the session. Is not nullable.
execution_duration_msbigintThe total amount of time, in milliseconds, that the target has been executing. Is not nullable.
target_datanvarchar(max)The data that the target maintains, such as event aggregation information. Is nullable.

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

FromToRelationship
sys.dm_xe_session_targets.event_session_addresssys.dm_xe_sessions.addressMany-to-one
Updated content
Corrected the data type for the target_data column.
Corrected the description for the target_data column to indicate that the value is nullable.
Corrected the "Relationship Cardinalities" table.

Dynamic Management Views and Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft