Delen via


sys.dm_os_process_memory (Transact-SQL)

Most memory allocations that are attributed to the SQL Server process space are controlled through interfaces that allow for tracking and accounting of those allocations. However, memory allocations might be performed in the SQL Server address space that bypasses internal memory management routines. Values are obtained through calls to the base operating system. They are not manipulated by methods internal to SQL Server, except when it adjusts for locked or large page allocations.

All returned values that indicate memory sizes are shown in kilobytes (KB). The column total_virtual_address_space_reserved_kb is a duplicate of virtual_memory_in_bytes from sys.dm_os_sys_info.

The following table provides a complete picture of the process address space.

Column name

Data type

Description

physical_memory_in_use

bigint

Process working set in KB, as reported by operating system, plus tracked allocations done by using large page and AWE APIs.

large_page_allocations_kb

bigint

Physical memory that is allocated by using large page APIs.

locked_page_allocations_kb

bigint

Physical memory that is allocated by using AWE APIs.

total_virtual_address_space_kb

bigint

Ttotal size of the user mode part of the virtual address space.

virtual_address_space_reserved_kb

bigint

Number of virtual address reservations that is neither committed nor mapped physical pages.

virtual_address_space_committed_kb

bigint

Amount of virtual address that has been committed or mapped to physical pages.

virtual_address_space_available_kb

bigint

Amount of virtual address space that is currently free.

page_fault_count

bigint

Number of page faults that are incurred by the SQL Server process.

memory_utilization_percentage

int

Percentage of committed memory that is in the working set.

available_commit_limit_kb

bigint

Amount of memory that is available to be committed by the process.

process_physical_memory_low

bit

Process is responding to low physical memory notification.

process_virtual_memory_low

bit

Low virtual memory condition has been detected.

Permissions

Requires VIEW SERVER STATE permission on the server.