Both sp_cacheconfig and sp_helpcache display the current default data cache in megabytes. For example, the following shows an Adaptive Server configured with 19.86MB of default data cache:
sp_cacheconfig
Cache Name Status Type Config Value Run Value ------------------ -------- -------- ------------ ---------- default data cache Active Default 0.00 Mb 19.86Mb ------------ -------- Total 0.00Mb 19.86 Mb ======================================================================== Cache: default data cache, Status: Active, Type: Default Config Size: 0.00 Mb, Run Size: 19.86 Mb Config Replacement: strict LRU, Run Replacement: strict LRU Config Partition: 1, Run Partition: 1 IO Size Wash Size Config Size Run Size APF Percent -------- --------- ------------ ---------- ----------- 2 Kb 4066 Kb 0.00 Mb 19.86 Mb 10
To change the default data cache, issue sp_cacheconfig, and specify “default data cache.” For example, to change the default data cache to 25MB, enter:
sp_cacheconfig "default data cache", "25M"
You must restart Adaptive Server for this change to take effect.
The default data cache size is an absolute value, and the minimum size for the cache size is 256 times the logical page size; for 2K, the minimum is 512K, for 16K, the minimum is 4M. The default value is 8MB. During the upgrade process, Adaptive Server sets the default data cache size to the value of the default data cache in the configuration file.