Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
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. |
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. |
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 has changes that are not 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. This information is cache implementation dependant. Is 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