| title | sys.dm_os_virtual_address_dump (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/15/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine, sql-data-warehouse, pdw | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 7b24ea55-3873-42fd-a86c-441c92eb6175 | ||||
| author | stevestein | ||||
| ms.author | sstein | ||||
| monikerRange | >=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEtsql-appliesto-ss2008-xxxx-asdw-pdw-md]
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 [!INCLUDEssSDWfull] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_os_virtual_address_dump.
| 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: [!INCLUDEssSDWfull], [!INCLUDEssPDW] The identifier for the node that this distribution is on. |
Requires VIEW SERVER STATE permission on the server.
Dynamic Management Views and Functions (Transact-SQL)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)