master database
Provides information about data caches and pools.
Access to the views is restricted to users with the sa_role role.
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. |
