Share via

sys.dm_os_virtual_address_dump

  • 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
SQL Server Operating System Related Dynamic Management Views

Help and Information

Getting SQL Server 2005 Assistance