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.