sys.dm_xe_session_targets (Transact-SQL)
Applies to:
SQL Server
Azure SQL Managed Instance
Returns information about active server-scoped session targets.
Azure SQL Database supports only database-scoped sessions. See sys.dm_xe_database_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. |
bytes_written | bigint | Applies to: SQL Server 2017 and later. Number of bytes written to target. Is not nullable. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE 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 |
Next steps
Learn more about related concepts in the following articles: