sys.dm_xe_objects (Transact-SQL)
Returns a row for each object that is exposed by an event package. Objects can be one of the following:
Events. Events indicate points of interest in an execution path. All events contain information about a point of interest.
Actions. Actions are run synchronously when events fire. An action can append run time data to an event.
Targets. Targets consume events, either synchronously on the thread that fires the event or asynchronously on a system-provided thread.
Predicates. Predicate sources retrieve values from event sources for use in comparison operations. Predicate comparisons compare specific data types and return a Boolean value.
Types. Types encapsulate the length and characteristics of the byte collection, which is required in order to interpret the data.
Column name |
Data type |
Description |
---|---|---|
name |
nvarchar(60) |
The name of the object. name is unique within a package for a specific object type. Is not nullable. |
object_type |
nvarchar(60) |
The type of the object. object_type is one of the following:
Is not nullable. |
package_guid |
uniqueidentifier |
The GUID for the package that exposes this action. There is a many-to-one relationship with sys.dm_xe_packages.package_id. Is not nullable. |
description |
nvarchar(256) |
A description of the action. description is set by the package author. Is not nullable. |
capabilities |
int |
A bitmap that describes the capabilities of the object. Is nullable. |
capabilities_desc |
nvarchar(256) |
Lists all the capabilities of the object. Is nullable. |
type_name |
nvarchar(60) |
The name for pred_source and pred_compare objects. Is nullable. |
type_package_guid |
uniqueidentifier |
The GUID for the package that exposes the type that this object operates on. Is nullable. |
type_size |
int |
The size, in bytes, of the data type. This is only for valid object types. Is nullable. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Relationship Cardinalities
From |
To |
Relationship |
---|---|---|
sys.dm_xe_objects.package_guid |
sys.dm_xe_packages.guid |
Many-to-one |