sys.dm_os_memory_pools (Transact-SQL)

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

Column name

Data type

Description

memory_pool_address

varbinary(8)

Memory address of the entry that represents the memory pool. Is not nullable.

pool_id

int

ID of a specific pool within a set of pools. Is not nullable.

type

nvarchar(60)

Type of object pool. Is not nullable. For more information, see sys.dm_os_memory_clerks (Transact-SQL).

name

nvarchar(256)

System-assigned name of this memory object. Is not nullable.

max_free_entries_count

bigint

Maximum number of free entries that a pool can have. Is not nullable.

free_entries_count

bigint

Number of free entries currently in the pool. Is not nullable.

removed_in_all_rounds_count

bigint

Number of entries removed from the pool since the instance of SQL Server was started. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

Remarks

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.