Export (0) Print
Expand All
Expand Minimize

sys.dm_os_memory_cache_counters (Transact-SQL)

Returns a snapshot of the health of a cache in SQL Server 2012. sys.dm_os_memory_cache_counters provides run-time information about the cache entries allocated, their use, and the source of memory for the cache entries.

Column name

Data type

Description

cache_address

varbinary(8)

Indicates the address (primary key) of the counters associated with a specific cache. Is not nullable.

name

nvarchar(256)

Specifies the name of the cache. Is not nullable.

type

nvarchar(60)

Indicates the type of cache that is associated with this entry. Is not nullable.

pages_kb

bigint

Specifies the amount, in kilobytes, of the memory allocated in the cache. Is not nullable.

pages_in_use_kb

bigint

Specifies the amount, in kilobytes, of the memory that is allocated and in use in the cache. Is nullable. Values for objects of type USERSTORE_<*> are not tracked. NULL is reported for them.

entries_count

bigint

Indicates the number of entries in the cache. Is not nullable.

entries_in_use_count

bigint

Indicates the number of entries in the cache that is being used. Is not nullable.

Requires VIEW SERVER STATE permission on the server.

In SQL Server 2012, the following columns have been renamed.

Previous Column Name

New Column Name

single_pages_kb

pages_kb

multi_pages_kb

pages_in_use_kb

In SQL Server 2012, the following columns have been removed.

  • single_pages_in_use_kb

  • multi_pages_in_use_kb

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft