This topic has not yet been rated - Rate this topic

sys.dm_os_virtual_address_dump (Transact-SQL)

SQL Server 2008 R2

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.

Requires VIEW SERVER STATE permission on the server.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions