To completely remove a pool, reset its size to 0. The following removes the 16K pool and places all space in the default pool:
sp_poolconfig "default data cache", "0", " 16K”sp_cacheconfig "default data cache"
Cache Name Status Type Config Value Run Value ------------------------ --------- -------- ------------ ------------ default data cache Active Default 25.00 Mb 29.28 Mb ------------ ------------ Total 25.00 Mb 29.28 Mb ======================================================================= Cache: default data cache, Status: Active, Type: Default Config Size: 25.00 Mb, Run Size: 29.28 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 3844 Kb 6.50 Mb 25.28 Mb 10 4 Kb 512 Kb 4.00 Mb 4.00 Mb 10
If you do not specify the affected pool size (16K in the example above), all the space is placed in the default pool. You cannot delete the default pool in any cache.
