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:
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru