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