sys-dm-os-process-memory-transact-sql.md

title	sys.dm_os_process_memory (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine, sql-data-warehouse, pdw
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.dm_os_process_memory_TSQL dm_os_process_memory_TSQL dm_os_process_memory sys.dm_os_process_memory
dev_langs	TSQL
helpviewer_keywords	sys.dm_os_process_memory dynamic management view
ms.assetid	e838130c-95d4-4605-9e3b-eb0ab71cd250
author	stevestein
ms.author	sstein
manager	craigg
monikerRange	>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_os_process_memory (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-asdw-pdw-md]

Most memory allocations that are attributed to the [!INCLUDEssNoVersion] process space are controlled through interfaces that allow for tracking and accounting of those allocations. However, memory allocations might be performed in the [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion], 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.

Note

To call this from [!INCLUDEssSDWfull] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_os_process_memory.

Column name	Data type	Description
physical_memory_in_use_kb	bigint	Indicates the process working set in KB, as reported by operating system, as well as tracked allocations by using large page APIs. Not nullable.
large_page_allocations_kb	bigint	Specifies physical memory allocated by using large page APIs. Not nullable.
locked_page_allocations_kb	bigint	Specifies memory pages locked in memory. Not nullable.
total_virtual_address_space_kb	bigint	Indicates the total size of the user mode part of the virtual address space. Not nullable.
virtual_address_space_reserved_kb	bigint	Indicates the total amount of virtual address space reserved by the process. Not nullable.
virtual_address_space_committed_kb	bigint	Indicates the amount of reserved virtual address space that has been committed or mapped to physical pages. Not nullable.
virtual_address_space_available_kb	bigint	Indicates the amount of virtual address space that is currently free. Not nullable. Note: Free regions that are smaller than the allocation granularity can exist. These regions are unavailable for allocations.
page_fault_count	bigint	Indicates the number of page faults that are incurred by the [!INCLUDEssNoVersion] process. Not nullable.
memory_utilization_percentage	int	Specifies the percentage of committed memory that is in the working set. Not nullable.
available_commit_limit_kb	bigint	Indicates the amount of memory that is available to be committed by the process. Not nullable.
process_physical_memory_low	bit	Indicates that the process is responding to low physical memory notification. Not nullable.
process_virtual_memory_low	bit	Indicates that low virtual memory condition has been detected. Not nullable.
pdw_node_id	int	Applies to: [!INCLUDEssSDWfull], [!INCLUDEssPDW] The identifier for the node that this distribution is on.

Permissions

On [!INCLUDEssNoVersion] requires VIEW SERVER STATE permission on the server.

On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md], requires the VIEW DATABASE STATE permission in the database.

See Also

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