TechNet
Export (0) Print
Expand All

sys.dm_xe_session_object_columns (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Column nameData typeDescription
event_session_addressvarbinary(8)The memory address of the event session. Has a many-to-one relationship with sys.dm_xe_sessions.address. Is not nullable.
column_namenvarchar(60)The name of the configuration value. Is not nullable.
column_idintThe ID of the column. Is unique within the object. Is not nullable.
column_valuenvarchar(2048)The configured value of the column. Is nullable.
object_typenvarchar(60)The type of the object. Is not nullable. object_type is one of:

event

target
object_namenvarchar(60)The name of the object to which this column belongs. Is not nullable.
object_package_guiduniqueidentifierThe GUID of the package that contains the object. Is not nullable.

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

FromToRelationship
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

Dynamic Management Views and Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft