Updated: June 10, 2016
Returns information about session targets.
|Column name||Data type||Description|
|event_session_address||varbinary(8)||The memory address of the event session. Has a many-to-one relationship with sys.dm_xe_sessions.address. Is not nullable.|
|target_name||nvarchar(60)||The name of the target within a session. Is not nullable.|
|target_package_guid||uniqueidentifier||The GUID of the package that contains the target. Is not nullable.|
|execution_count||bigint||The number of times the target has been executed for the session. Is not nullable.|
|execution_duration_ms||bigint||The total amount of time, in milliseconds, that the target has been executing. Is not nullable.|
|target_data||nvarchar(max)||The data that the target maintains, such as event aggregation information. Is nullable.|
Requires VIEW SERVER STATE permission on the server.
|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.|