sys.dm_os_memory_pools (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns a row for each object store in the instance of SQL Server. You can use this view to monitor cache memory use and to identify bad caching behavior

System_CAPS_ICON_note.jpg Note

To call this from Azure SQL Data Warehouse or Parallel Data Warehouse, use the name sys.dm_pdw_nodes_os_memory_pools.

Column nameData typeDescription
memory_pool_addressvarbinary(8)Memory address of the entry that represents the memory pool. Is not nullable.
pool_idintID of a specific pool within a set of pools. Is not nullable.
typenvarchar(60)Type of object pool. Is not nullable. For more information, see sys.dm_os_memory_clerks (Transact-SQL).
namenvarchar(256)System-assigned name of this memory object. Is not nullable.
max_free_entries_countbigintMaximum number of free entries that a pool can have. Is not nullable.
free_entries_countbigintNumber of free entries currently in the pool. Is not nullable.
removed_in_all_rounds_countbigintNumber of entries removed from the pool since the instance of SQL Server was started. Is not nullable.
pdw_node_idintApplies to: Azure SQL Data Warehouse, Parallel Data Warehouse

The identifier for the node that this distribution is on.

Requires VIEW SERVER STATE permission on the server.

SQL Server components sometimes use a common pool framework to cache homogeneous, stateless types of data. The pool framework is simpler than cache framework. All entries in the pools are considered equal. Internally, pools are memory clerks and can be used in places where memory clerks are used.

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

Community Additions