sp_cacheconfig reports that pubs_cache is currently configured with 10MB of space:
sp_cacheconfig pubs_cache
Cache Name Status Type Config Value Run Value ------------------------ --------- -------- ------------ ------------ pubs_cache Active Mixed 10.00 Mb 10.00 Mb ------------ ------------ Total 10.00 Mb 10.00 Mb ======================================================================= Cache: pubs_cache, Status: Active, Type: Mixed Config Size: 10.00 Mb, Run Size: 10.00 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 720 Kb 0.00 Mb 3.00 Mb 20 16 Kb 1424 Kb 7.00 Mb 7.00 Mb 10
To increase the size of the cache and its pool, specify the new total size of the cache:
sp_cacheconfig pubs_cache, "20M"
This output reports the configuration of the pubs_cache before a restart:
Cache Name Status Type Config Value Run Value ------------------------ --------- -------- ------------ ------------ pubs_cache Active Mixed 20.00 Mb 10.00 Mb ------------ ------------ Total 20.00 Mb 10.00 Mb ======================================================================= Cache: pubs_cache, Status: Active, Type: Mixed Config Size: 10.00 Mb, Run Size: 10.00 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 720 Kb 0.00 Mb 3.00 Mb 20 16 Kb 1424 Kb 7.00 Mb 7.00 Mb 10
The additional 10MB has been configured and becomes available in the pool at the next restart.
