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.
Relationship Cardinalities
|
From |
To |
Relationship |
|---|---|---|
|
sys.dm_xe_session_targets.event_session_address |
sys.dm_xe_sessions.address |
Many-to-one |
Reference
|
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. |