Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sys.dm_os_memory_cache_entries (Transact-SQL)

Returns information about all entries in caches in SQL Server. Use this view to trace cache entries to their associated objects. You can also use this view to obtain statistics on cache entries.

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type

Description

cache_address

varbinary(8)

Address of the cache. Is not nullable.

name

nvarchar(256)

Name of the cache. Is not nullable.

type

varchar(60)

Type of cache. Is not nullable.

entry_address

varbinary(8)

Address of the descriptor of the cache entry. Is not nullable.

entry_data_address

varbinary(8)

Address of the user data in the cache entry.

0x00000000 = Entry data address is not available.

Is not nullable.

in_use_count

int

Number of concurrent users of this cache entry. Is not nullable.

is_dirty

bit

Indicates whether this cache entry is marked for removal. 1 = marked for removal. Is not nullable.

disk_ios_count

int

Number of I/Os incurred while this entry was created. Is not nullable.

context_switches_count

int

Number of context switches incurred while this entry was created. Is not nullable.

original_cost

int

Original cost of the entry. This value is an approximation of the number of I/Os incurred, CPU instruction cost, and the amount of memory consumed by entry. The greater the cost, the lower the chance that the item will be removed from the cache. Is not nullable.

current_cost

int

Current cost of the cache entry. This value is updated during the process of entry purging. Current cost is reset to its original value on entry reuse. Is not nullable.

memory_object_address

varbinary(8)

Address of the associated memory object. Is nullable.

pages_allocated_count

bigint

Number of 8-KB pages to store this cache entry. Is not nullable.

Applies to: SQL Server 2008 through SQL Server 2008 R2.

pages_kb

bigint

Amount of memory in kilobytes (KB) used by this cache entry. Is not nullable.

Applies to: SQL Server 2012 through SQL Server 2014.

entry_data

nvarchar(2048)

Serialized representation of the cached entry. This information is cache store dependant. Is nullable.

pool_id

int

Resource pool id associated with entry. Is nullable.

not katmai

Applies to: SQL Server 2008 R2 through SQL Server 2014.

Requires VIEW SERVER STATE permission on the server.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.