sys.dm_xe_session_object_columns (Transact-SQL)

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: