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.


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

Next steps

Learn more about related concepts in the following articles: