sys.dm_xe_database_session_object_columns (Azure SQL Database and Azure SQL Managed Instance)

Applies to: Azure SQL Database Azure SQL Managed Instance

Shows the configuration values for objects that are bound to an active database-scoped session.

Azure SQL Database supports only database-scoped sessions. Azure SQL Managed Instance supports both database-scoped sessions and server-scoped sessions. Server-scoped sessions are recommended for managed instances: learn more in CREATE EVENT SESSION.

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
dm_xe_database_session_object_columns.object_name

dm_xe_database_session_object_columns.object_package_guid
sys.dm_xe_objects.package_guid

sys.dm_xe_objects.name
Many-to-one
dm_xe_database_session_object_columns.column_name

dm_xe_database_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 Extended Events and related concepts in the following articles: