syscacheinfo

master database

Description

Provides information about data caches.

syscacheinfo is a view of the master database that provides information about the configuration of data caches and pools.

Columns

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:

  • Active

  • Pend/Act

  • Act/Del

cache_type

varchar(16)

Type of cache. One of:

  • Mixed, HK Ignore

  • Mixed

  • Log Only

  • In-Memory Storage

  • Default

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:

  • Strict LRU

  • Relaxed LRU

run_replacement

varchar(11)

Current buffer replacement strategy for the cache. None, or one of:

  • Strict LRU

  • Relaxed LRU

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.