syspoolinfo

master database

Description

Provides information about data caches and pools.

Columns

The columns for syspoolinfo are:

Name

Datatype

Description

cache_name

varchar(30)

Name of the cache in which this pool is allocated.

io_size

varchar(3)

The size of the buffers, in kilobytes, used to perform I/O for this 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.

run_size

float

The current amount of memory, in megabytes, allocated to the 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.

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.