sys.dm_os_virtual_address_dump (Transact-SQL)

  • Article

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.

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.

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Reference

Dynamic Management Views and Functions (Transact-SQL)

SQL Server Operating System Related Dynamic Management Views (Transact-SQL)