Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: View the Extended Events Targets for Registered Packages

Before you create a SQL ServerExtended Events session it is useful to find out what Extended Events targets are available.

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 two columns:

  • package_name

  • target_name

To view the extended events targets for registered packages

  • 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' 
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.