Moving Space from the Memory Pool

Use sp_cacheconfig to check the current configuration of the pubs_log cache.

For example, this output 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

To increase the size of the 4K pool to 5MB, moving the required space from the 2K pool, enter:

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