sys.dm_xe_database_session_object_columns

2025-07-30

Applies to: Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric Preview

The sys.dm_xe_database_session_object_columns dynamic management view (DMV) shows the configuration values for objects that are bound to an active database-scoped session.

Azure SQL Database and SQL database in Fabric support only database-scoped sessions.
Azure SQL Managed Instance supports both database-scoped sessions and server-scoped sessions. Server-scoped sessions are recommended for SQL managed instances. For more information, see CREATE EVENT SESSION code examples.

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_database_sessions.address`. Is not nullable.
`column_name`	nvarchar(60)	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(2048)	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(60)	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 the VIEW DATABASE STATE permission.

Relationship cardinalities

From	To	Relationship
`sys.dm_xe_database_session_object_columns.object_name` `sys.dm_xe_database_session_object_columns.object_package_guid`	`sys.dm_xe_objects.package_guid` `sys.dm_xe_objects.name`	Many-to-one
`sys.dm_xe_database_session_object_columns.column_name` `sys.dm_xe_database_session_object_columns.column_id`	`sys.dm_xe_object_columns.name` `sys.dm_xe_object_columns.column_id`	Many-to-one