Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

View the Extended Events Targets for Registered Packages

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Before you create a SQL Server Extended Events session, it is useful to determine what Extended Events targets are available. This task involves using Query Editor in SQL Server Management Studio to perform the following procedure.

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

  • package_name

  • target_name

  • In Query Editor, issue the following statements.

    USE msdb
    SELECT p.name package_name, o.name target_name
    FROM sys.dm_xe_objects o
    JOIN sys.dm_xe_packages p
         ON o.package_guid = p.guid
    WHERE o.object_type = 'target'
    

Community Additions

ADD
Show:
© 2015 Microsoft