Επεξεργασία

Κοινή χρήση μέσω

sys.dm_xe_packages (Transact-SQL)

  • Άρθρο

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

Lists all the packages registered with the extended events engine.

Column name Data type Description
name nvarchar(256) The name of package. The description is exposed from the package itself. Is not nullable.
guid uniqueidentifier The GUID that identifies the package. Is not nullable.
description nvarchar(3072) The package description. description is set by the package author and is not nullable.
capabilities int Bitmap describing the capabilities of this package. Is nullable.
capabilities_desc nvarchar(256) A list of all the capabilities possible for this package. Is nullable.
module_guid nvarchar(60) The GUID of the module that exposes this package. Is not nullable.
module_address varbinary(8) The base address where the module containing the package is loaded. A single module may expose several packages. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

Remarks

The packages registered with the extended events engine expose events, the actions that can be taken at the time of event firing, and targets for both synchronous and asynchronous processing of event data.

These packages can be dynamically loaded into a process address space. At the time the package is loaded, it registers all the objects it exposes with the extended events engine.

Relationship cardinalities

From To Relationship
sys.dm_xe_packages.module_address sys.dm_os_loaded_modules.base_address Many to one

Next steps

Learn more about related concepts in the following articles: