This topic has not yet been rated - Rate this topic

Get the Fields for All Events

SQL Server 2012

Accomplishing this task involves using Query Editor in SQL Server Management Studio.

After the statements in this procedure finish, the Results tab of Query Editor displays the following columns:

package_name
event_name
event_field
field_type
column_type

You can use the preceding information when configuring event sessions that use the bucketing target. For more information, see SQL Server Extended Events Targets.

Before you Begin

Before you create a SQL Server Extended Events session, it is useful to get information about the fields associated with events.

To get the fields for all events using Query Editor

In Query Editor, issue the following statements.

select p.name package_name, o.name event_name, c.name event_field, c.type_name field_type, c.column_type column_type
from sys.dm_xe_objects o
join sys.dm_xe_packages p
      on o.package_guid = p.guid
join sys.dm_xe_object_columns c
      on o.name = c.object_name
where o.object_type = 'event'
order by package_name, event_name

Reference

sys.dm_xe_objects (Transact-SQL)

sys.dm_xe_packages (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD