Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_xe_session_object_columns (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Shows the configuration values for objects that are bound to a session.

Applies to: SQL Server (SQL Server 2008 through current version).

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

Community Additions

ADD
Show:
© 2015 Microsoft