Share via


sys.dm_xe_session_targets (Transact-SQL)

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.

Permissions

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

From

To

Relationship

sys.dm_xe_session_targets.event_session_address

sys.dm_xe_sessions.address

Many-to-one

See Also

Reference

Dynamic Management Views and Functions (Transact-SQL)

Change History

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.