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.service: "" ms.component: "dmv's" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "dm_os_virtual_address_dump"
- "sys.dm_os_virtual_address_dump_TSQL"
- "sys.dm_os_virtual_address_dump"
- "dm_os_virtual_address_dump_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.dm_os_virtual_address_dump dynamic management view" ms.assetid: 7b24ea55-3873-42fd-a86c-441c92eb6175 caps.latest.revision: 23 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!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)