master database
Provides information about data caches.
syscacheinfo is a view of the master database that provides information about the configuration of data caches and pools.
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:
|
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. |
run_size |
float |
The current amount of memory, in megabytes, allocated to the cache. May be different from the configured size reported by the config_size column. |
config_replacement |
varchar(11) |
Currently configured buffer replacement strategy. None, or one of:
|
run_replacement |
varchar(11) |
Current buffer replacement strategy for the cache. None, or one of:
|
config_partitions |
int |
Configured number of partitions in the data cache. |
run_partitions |
int |
The current number of partitions in the data cache. |
overhead |
numeric |
Amount of memory overhead for the data cache. |
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. |
