This command checks the current configuration of the pubs_log cache (the output in this example is based on the examples in the previous sections):
sp_cacheconfig pubs_log
Cache Name Status Type Config Value Run Value ------------------------ --------- -------- ------------ ------------ pubs_log Active Log Only 6.00 Mb 6.00 Mb ------------ ------------ Total 6.00 Mb 6.00 Mb ======================================================================= Cache: pubs_log, Status: Active, Type: Log Only Config Size: 6.00 Mb, Run Size: 6.00 Mb Config Replacement: relaxed LRU, Run Replacement: relaxed LRU Config Partition: 1, Run Partition: 1 IO Size Wash Size Config Size Run Size APF Percent -------- --------- ------------ ------------ ----------- 2 Kb 716 Kb 0.00 Mb 3.50 Mb 10 4 Kb 512 Kb 2.50 Mb 2.50 Mb 10
This command increases the size of the 4K pool to 5MB, moving the required space from the 2K pool:
sp_poolconfig pubs_log, "5M", "4K"sp_cacheconfig pubs_log
Cache Name Status Type Config Value Run Value ------------------------ --------- -------- ------------ ------------ pubs_log Active Log Only 6.00 Mb 6.00 Mb ------------ ------------ Total 6.00 Mb 6.00 Mb ======================================================================= Cache: pubs_log, Status: Active, Type: Log Only Config Size: 6.00 Mb, Run Size: 6.00 Mb Config Replacement: relaxed LRU, Run Replacement: relaxed LRU Config Partition: 1, Run Partition: 1 IO Size Wash Size Config Size Run Size APF Percent -------- --------- ------------ ------------ ----------- 2 Kb 716 Kb 0.00 Mb 1.00 Mb 10 4 Kb 1024 Kb 5.00 Mb 5.00 Mb 10
