| title | titleSuffix | description | author | ms.author | ms.date | ms.service | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_xe_database_session_object_columns |
Azure SQL Database and Azure SQL Managed Instance |
sys.dm_xe_database_session_object_columns (Azure SQL Database and Azure SQL Managed Instance) |
rwestMSFT |
randolphwest |
4/18/2022 |
azure-sql-database |
reference |
|
=azuresqldb-current |
[!INCLUDEAzure SQL Database and 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. |
Requires the VIEW DATABASE STATE permission.
| 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 |
Learn more about Extended Events and related concepts in the following articles:
- Extended events in Azure SQL Database
- Event File target code for extended events in Azure SQL Database and SQL Managed Instance
- sys.dm_xe_database_session_targets (Azure SQL Database and Azure SQL Managed Instance)
- sys.dm_xe_database_sessions (Azure SQL Database and Azure SQL Managed Instance)
- Monitoring Microsoft Azure SQL Database and Azure SQL Managed Instance performance using dynamic management views