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: