Export (0) Print
Expand All
Expand Minimize

sys.dm_os_virtual_address_dump (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Note Note

This information is also returned by the VirtualQuery Windows API.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Data Warehouse Public Preview.

Note Note

To call this from SQL Data Warehouse, 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.

Requires VIEW SERVER STATE permission on the server.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft