| title | sys.dm_os_virtual_address_dump (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_os_virtual_address_dump (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 02/27/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | >=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE sql-asdbmi-asa-pdw]
Returns information about a range of pages in the virtual address space of the calling process.
Note
This information is also returned by the VirtualQuery Windows API.
Note
To call this from [!INCLUDEssazuresynapse-md] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_os_virtual_address_dump. [!INCLUDEsynapse-analytics-od-unsupported-syntax]
| Column name | Data type | Description |
|---|---|---|
| region_base_address | varbinary(8) | Pointer to the base address of the region of pages. Is not nullable. |
| region_allocation_base_address | varbinary(8) | Pointer to the base address of a range of pages allocated by the VirtualAlloc Windows API function. The page pointed to by the BaseAddress member is contained within this allocation range. Is not nullable. |
| region_allocation_protection | varbinary(8) | Protection attributes when the region was first allocated. The value is one of the following: - PAGE_READONLY - PAGE_READWRITE - PAGE_NOACCESS - PAGE_WRITECOPY - PAGE_EXECUTE - PAGE_EXECUTE_READ - PAGE_EXECUTE_READWRITE - PAGE_EXECUTE_WRITECOPY - PAGE_GUARD - PAGE_NOCACHE Is not nullable. |
| region_size_in_bytes | bigint | Size of the region, in bytes, starting at the base address in which all the pages have the same attributes. Is not nullable. |
| region_state | varbinary(8) | Current state of the region. This is one of the following: - MEM_COMMIT - MEM_RESERVE - MEM_FREE Is not nullable. |
| region_current_protection | varbinary(8) | Protection attributes. The value is one of the following: - PAGE_READONLY - PAGE_READWRITE - PAGE_NOACCESS - PAGE_WRITECOPY - PAGE_EXECUTE - PAGE_EXECUTE_READ - PAGE_EXECUTE_READWRITE - PAGE_EXECUTE_WRITECOPY - PAGE_GUARD - PAGE_NOCACHE Is not nullable. |
| region_type | varbinary(8) | Identifies the types of pages in the region. The value can be one of the following: - MEM_PRIVATE - MEM_MAPPED - MEM_IMAGE Is not nullable. |
| pdw_node_id | int | Applies to: [!INCLUDEssazuresynapse-md], [!INCLUDEssPDW] The identifier for the node that this distribution is on. |
Requires VIEW SERVER STATE permission on the server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Dynamic Management Views and Functions (Transact-SQL)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)