CAche sizes and buffer pools

Memory page sizes are in multiples of 2K (i.e. max memory, total logical memory, and so on), procedure cache is in terms of 2K pages. Buffer cache is in terms of logical page size units.

Large I/O is scaled in terms of an extent I/O. This means that with an 8K logical page size, a large I/O means a 64k read/write.

If you boot Adaptive Server where the caches are defined with buffer pools that are not valid for the current logical page size, all memory for such inapplicable buffer pools is reallocated when configuring caches to the default buffer pool in each named cache.

You have to be careful in how you set up the logical page sizes and what you allow for in the buffer pool sizes.

Logical page size

Possible buffer pool sizes

2K

2K, 4K, 16K

4K

      4K, 8K, 16K, 32K

8K

            8K, 16K, 32K, 64K

16K

                  16K, 32K, 64K, 128K