Provides a row for each data cache pool that includes configuration information for the data cache. This view is a join between the syscacheinfo and syspoolinfo views.
Access to the views is restricted to users with the sa_role role.
The columns for syscacheinfo are:
Name |
Datatype |
Description |
|---|---|---|
cache_name |
varchar(30) |
Name of the cache in which this pool is allocated. |
cache_status |
varchar(8) |
Status of the cache. One of:
|
cache_type |
varchar(16) |
Type of cache. One of:
|
cache_config_size |
float |
The currently configured size of the cache, in megabytes. May be different from the actual size of the cache, reported in the run_size column. |
cache_run_size |
float |
The current amount of memory allocated to the cache, in megabytes. May be different from the configured size reported by the config_size column. |
cache_config_replacement |
varchar(11) |
Currently configured buffer replacement strategy. None, or one of:
|
cache_run_replacement |
varchar(11) |
Current buffer replacement strategy for the cache. None, or one of:
|
cache_config_partitions |
int |
Configured number of partitions in the data cache. |
cache_run_partitions |
int |
The current number of partitions in the data cache. |
cache_overhead |
numeric |
Amount of memory overhead for the data cache. |
pool_io_size |
varchar(3) |
The size of the buffers, in kilobytes, used to perform I/O for this pool. |
pool_config_size |
float |
Configured amount of memory, in megabytes, allocated to the pool. May be different from the amount reported in the run_size column. |
pool_run_size |
float |
The current amount of memory, in megabytes, allocated to the pool. |
pool_apf_percent |
int |
The percentage of buffers in the pool that can be used to hold buffers that have been read into cache by asynchronous prefetch. |
pool_wash_size |
varchar(10) |
The size of the wash area, in megabytes, in the pool. |
cacheid |
int |
ID of the data cache. |
instanceid |
int |
ID of the instance (zero for non-Cluster Edition servers). |
scope |
varchar(6) |
Indicates whether the data cache is local or global for Cluster Edition. The value is always Global for nonclustered servers. |
