Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

sys.dm_os_virtual_address_dump

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

ms186294.note(en-US,SQL.90).gifNote:
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.

Requires VIEW SERVER STATE permission on the server.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.