Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.dm_os_memory_cache_entries

 

This is a view in the mssqlsystemresource database. Returns information, such as statistics, for all entries in the various caches. This DMV is useful for linking cache entries back to their associated database objects. You can find out how much memory is allocated for a pool from a given clerk or memory object by extracting the information from a full dump using a custom script and the sys.dm_os_memory_cache_entries dynamic management view shows the pool_id that each each entry is associated with. Returns information about all entries in caches. Use this view to trace cache entries to their associated objects. You can also use this view to obtain statistics on cache entries.

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. Sample types are:
USERSTORE_TOKENPERM
USERSTORE_SXC
CACHESTORE_SYSTEMROWSET
USERSTORE_SCHEMAMGR
USERSTORE_DBMETADATA

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

1 = This cache entry has changes that have not been persisted.
Is not nullable.

disk_ios_count

int

Number of I/Os incurred because of this entry. Is not nullable.

context_switches_count

int

Number of context switches incurred because of this entry. 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 context switch count. 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.

entry_data

nvarchar(2048)

Serialized representation of the cached entry

 




Syntax
CREATE VIEW sys.dm_os_memory_cache_entries AS
	SELECT *
	FROM OpenRowset(TABLE SYSMEMORYCACHEENTRIES)

 
Last revision 2008RTM
News

  Query a named instance
Sybase+ASE+silent+install
SQL 2008 R2
Deprecated procedures in SQL2008
Reporting Services item-level role definitions
Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash