sys.dm_os_virtual_address_dump (Transact-SQL)

Artykuł
12/08/2014

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

[!UWAGA]

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.

Zobacz także

Odwołanie

Dynamic Management Views and Functions (Transact-SQL)

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