syscachepoolinfo

Description

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.

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

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:

  • Strict LRU

  • Relaxed LRU

cache_run_replacement

varchar(11)

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

  • Strict LRU

  • Relaxed LRU

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.