Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (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 Azure Synapse Analytics or Analytics Platform System (PDW), use the name sys.dm_pdw_nodes_os_virtual_address_dump. This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
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: Azure Synapse Analytics, Analytics Platform System (PDW) 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)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register today