TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sys.dm_os_virtual_address_dump (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns information about a range of pages in the virtual address space of the calling process.

System_CAPS_ICON_note.jpg Note


This information is also returned by the VirtualQuery Windows API.

System_CAPS_ICON_note.jpg Note


To call this from Azure SQL Data Warehouse or Parallel Data Warehouse, use the name sys.dm_pdw_nodes_os_virtual_address_dump.

Column nameData typeDescription
region_base_addressvarbinary(8)Pointer to the base address of the region of pages. Is not nullable.
region_allocation_base_addressvarbinary(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_protectionvarbinary(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_bytesbigintSize of the region, in bytes, starting at the base address in which all the pages have the same attributes. Is not nullable.
region_statevarbinary(8)Current state of the region. This is one of the following:

- MEM_COMMIT
- MEM_RESERVE
- MEM_FREE

Is not nullable.
region_current_protectionvarbinary(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_typevarbinary(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_idintApplies to: Azure SQL Data Warehouse, Parallel Data Warehouse

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)

Community Additions

ADD
Show:
© 2016 Microsoft