View the Events for Registered Packages

  • Artykuł

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 p.name, c.event, k.keyword, c.channel, 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 o.name=c.object_name
INNER JOIN sys.dm_xe_map_values v ON c.type_name=v.name 
AND c.column_value=cast(v.map_key AS nvarchar)
WHERE object_type='event' AND (c.name='CHANNEL' or c.name IS NULL)

) c LEFT JOIN 
(
SELECT event_package=c.object_package_guid, event=c.object_name, 
keyword=v.map_value
FROM sys.dm_xe_object_columns c INNER JOIN sys.dm_xe_map_values v 
ON c.type_name=v.name AND c.column_value=v.map_key 
AND c.type_package_guid=v.object_package_guid
INNER JOIN sys.dm_xe_objects o ON o.name=c.object_name 
AND o.package_guid=c.object_package_guid
WHERE object_type='event' AND c.name='KEYWORD' 
) k
ON
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

Zobacz także

Odwołanie

sys.dm_xe_objects (Transact-SQL)

sys.dm_xe_packages (Transact-SQL)

Inne zasoby

SQL Server Extended Events Packages