Export (0) Print
Expand All
Expand Minimize

sys.dm_os_memory_cache_hash_tables (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Data Warehouse Public Preview.

System_CAPS_noteNote

To call this from SQL Data Warehouse, use the name sys.dm_pdw_nodes_os_memory_cache_hash_tables.

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.

Requires VIEW SERVER STATE permission on the server.

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

Community Additions

ADD
Show:
© 2015 Microsoft