Skip to content

Latest commit

 

History

History
57 lines (46 loc) · 2.33 KB

sys-dm-xe-map-values-transact-sql.md

File metadata and controls

57 lines (46 loc) · 2.33 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.dm_xe_map_values (Transact-SQL)
sys.dm_xe_map_values (Transact-SQL)
rwestMSFT
randolphwest
02/27/2023
sql
system-objects
reference
sys.dm_xe_map_values
dm_xe_map_values
dm_xe_map_values_TSQL
sys.dm_xe_map_values_TSQL
sys.dm_xe_map_values dynamic management view
xe
TSQL

sys.dm_xe_map_values (Transact-SQL)

[!INCLUDE SQL Server Azure SQL DB Azure SQL Managed Instance]

Returns a mapping of internal numeric keys to human-readable text.

Column name Data type Description
name nvarchar(256) The name of the map. name is unique across the local system. Is not nullable.
object_package_guid uniqueidentifier The GUID of the package that contains the map. Is not nullable.
map_key int The internal key value. Is not nullable.
map_value nvarchar(3072) A description of the key value. 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.

Relationship cardinalities

From To Relationship
dm_xe_map_values.object_package_guid

dm_xe_map_values.name
sys.dm_xe_objects.package_guid

sys.dm_xe_objects.name
Many-to-one

Next steps

Learn more about related concepts in the following articles: