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

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