Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.dm_xe_session_object_columns (Transact-SQL)

Shows the configuration values for objects that are bound to a 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_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. object_type is one of:

  • event

  • target

Is not nullable.

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 VIEW SERVER 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

Updated content

Corrected the data type for the column_value column.

Corrected the description for the column_value column to indicate that the value is nullable.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.