| title | sys.dm_xe_packages (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_xe_packages (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 02/27/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| ms.custom |
|
||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server Azure SQL DB Azure SQL Managed Instance FabricSQLDB]
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. |
Requires VIEW SERVER STATE permission on the server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
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.
| From | To | Relationship |
|---|---|---|
| sys.dm_xe_packages.module_address | sys.dm_os_loaded_modules.base_address | Many to one |
Learn more about related concepts in the following articles:
- Dynamic Management Views and Functions (Transact-SQL)
- sys.dm_xe_sessions (Transact-SQL)
- sys.dm_xe_session_events (Transact-SQL)
- Extended events overview
- Quickstart: Extended events
- Extended events in Azure SQL Database
- Event File target code for extended events in Azure SQL Database and SQL Managed Instance