Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to:
SQL Server
Azure SQL Managed Instance
Shows the configuration values for objects that are bound to an active server-scoped session.
Azure SQL Database supports only database-scoped sessions. See sys.dm_xe_database_session_object_columns.
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. |
column_name | nvarchar(256) | The name of the configuration value. Is not nullable. |
column_id | int | The ID of the column. Is unique within the object. Is not nullable. |
column_value | nvarchar(3072) | The configured value of the column. Is nullable. |
object_type | nvarchar(60) | The type of the object. Is not nullable. object_type is one of: event target |
object_name | nvarchar(256) | The name of the object to which this column belongs. Is not nullable. |
object_package_guid | uniqueidentifier | The GUID of the package that contains the object. 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 |
---|---|---|
dm_xe_session_object_columns.object_name, dm_xe_session_object_columns.object_package_guid |
sys.dm_xe_objects.package_guid, sys.dm_xe_objects.name |
Many-to-one |
dm_xe_session_object_columns.column_name, dm_xe_session_object_columns.column_id |
sys.dm_xe_object_columns.name, sys.dm_xe_object_columns.column_id |
Many-to-one |
Next steps
Learn more about related concepts in the following articles: