| title | sys.dm_xe_session_object_columns (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_xe_session_object_columns (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 02/27/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server 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. |
Requires VIEW SERVER STATE permission on the server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
| 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 |
Learn more about related concepts in the following articles: