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) .gif "Important note") Important
If you are using the ring buffer target, we recommend that you set the max_memory target parameter to 2048 kilobytes (KB) to help avoid possible data truncation of the XML output. For more information about how to configure target parameters, see ALTER EVENT SESSION (Transact-SQL) or CREATE EVENT SESSION (Transact-SQL). For more information about when to use the different target types, see SQL Server Extended Events Targets.
|
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 |