| title | sys.dm_os_memory_cache_hash_tables (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/13/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 68b94f35-8f80-4d2b-bcde-7a21934219af | ||||
| caps.latest.revision | 25 | ||||
| author | JennieHubbard | ||||
| ms.author | jhubbard | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-all_md]
Returns a row for each active cache in the instance of [!INCLUDEssNoVersion].
Note
To call this from [!INCLUDEssSDWfull] or [!INCLUDEssPDW], 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. |
| pdw_node_id | int | The identifier for the node that this distribution is on. Applies to: [!INCLUDEssSDWfull], [!INCLUDEssPDW] |
On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md] Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On [!INCLUDEssSDS_md] Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)