View the Events for Registered Packages

Before you create a SQL Server Extended Events session, it is useful to find out what events are available in the registered packages. For more information, see SQL Server Extended Events Packages.

Accomplishing this task involves using Query Editor in SQL Server Management Studio to carry out the following procedure. 

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

  • name. The package name.

  • event. The event name.

  • keyword. A keyword derived from an internal numeric mapping table.

  • channel. The audience for an event.

  • description. The event description.

To view the events for registered packages using Query Editor

  • In Query Editor, issue the following statements.

    USE msdb
    SELECT, c.event, k.keyword,, c.description FROM
    SELECT event_package=o.package_guid, o.description, 
    event=c.object_name, channel=v.map_value
    FROM sys.dm_xe_objects o
    LEFT JOIN sys.dm_xe_object_columns c ON
    INNER JOIN sys.dm_xe_map_values v ON 
    AND c.column_value=cast(v.map_key AS nvarchar)
    WHERE object_type='event' AND ('CHANNEL' or IS NULL)
    ) c LEFT JOIN 
    SELECT event_package=c.object_package_guid, event=c.object_name, 
    FROM sys.dm_xe_object_columns c INNER JOIN sys.dm_xe_map_values v 
    ON AND c.column_value=v.map_key 
    AND c.type_package_guid=v.object_package_guid
    INNER JOIN sys.dm_xe_objects o ON 
    AND o.package_guid=c.object_package_guid
    WHERE object_type='event' AND'KEYWORD' 
    ) k
    k.event_package=c.event_package AND (k.event=c.event or k.event IS NULL)
    INNER JOIN sys.dm_xe_packages p ON p.guid=c.event_package
    ORDER BY keyword desc, channel, event

See Also


sys.dm_xe_objects (Transact-SQL)

sys.dm_xe_packages (Transact-SQL)


SQL Server Extended Events Packages