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. |
