sys.dm_os_memory_cache_hash_tables

Returns a row for each active cache in the instance of SQL Server.

Column name Data type Description

cache_address

varbinary(8)

Address (primary key) of the cache entry. Is not nullable.

name

nvarchar(256)

Name of the cache. Is not nullable.

type

nvarchar(60)

Type of cache. Is not nullable.

table_level

int

Hash table number. A particular cache may have multiple hash tables that correspond to different hash functions. Is not nullable.

buckets_count

int

Number of buckets in the hash table. Is not nullable.

buckets_in_use_count

int

Number of buckets that are currently being used. Is not nullable.

buckets_min_length

int

Minimum number of cache entries in a bucket. Is not nullable.

buckets_max_length

int

Maximum number of cache entries in a bucket. Is not nullable.

buckets_avg_length

int

Average number of cache entries in each bucket. Is not nullable.

buckets_max_length_ever

int

Maximum number of cached entries in a hash bucket for this hash table since the server was started. Is not nullable.

hits_count

bigint

Number of cache hits. Is not nullable.

misses_count

bigint

Number of cache misses. Is not nullable.

buckets_avg_scan_hit_length

int

Average number of examined entries in a bucket before the searched for an item was found. Is not nullable.

buckets_avg_scan_miss_length

int

Average number of examined entries in a bucket before the search ended unsuccessfully. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Reference

Dynamic Management Views and Functions
SQL Server Operating System Related Dynamic Management Views

Help and Information

Getting SQL Server 2005 Assistance