Explicitly configuring the default cache

You must explicitly configure the size of the default data cache because it is specified with an absolute value. Use sp_helpcache to see the amount of memory remaining that can be used for the cache. For example:

sp_helpcache
Cache Name                Config Size    Run Size        Overhead
-----------------------   -------------  ----------      ----------   
default data cache        50.00 Mb       50.00 Mb        3.65 Mb
pubs_cache                10.00 Mb       10.00 Mb        0.77 Mb

Memory Available For      Memory Configured
Named Caches              To Named Caches
--------------------      ----------------
91.26 Mb                  91.25 Mb

------------------ Cache Binding Information: ------------------ 

Cache Name       Entity Name    Type         Index Name     Status
----------         -----------      -----           ---------        ------

To specify the absolute size of the default data cache, execute sp_cacheconfig with default data cache and a size value. This command sets the default data cache size to 25MB:

sp_cacheconfig "default data cache", "25M"

When you rerun sp_helpconfig, “Config Value” shows the value.

sp_cacheconfig
Cache Name                Status    Type     Config Value Run Value
------------------------- --------- -------- ------------ ------------
default data cache        Active    Default      25.00 Mb     50.00 Mb
pubs_cache                Active    Mixed        10.00 Mb     10.00 Mb
                                             ------------ ------------
                                      Total      10.00 Mb     60.00 Mb
======================================================================
Cache: default data cache,   Status: Active,   Type: Default
    Config Size: 25.00 Mb,   Run Size: 50.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 10110 Kb     00.00 Mb    50.00 Mb      10
======================================================================
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   2048 Kb    0.00 Mb    10.00 Mb    10

You can change the size of any named cache by using sp_cacheconfig. Any changes you make to the size of any data cache do not affect the size of any other cache. Similarly, once you specify the size of the default data cache, the configuration of other user-defined caches does not alter the size of the default data cache.

NoteIf you configure the default data cache and then reduce max memory to a level that sets the total logical memory value higher than the max memory value, Adaptive Server will not start. Edit your configuration file to increase the size of other caches and increase the values of configuration parameters that require memory to create an environment in which total logical memory is higher than max memory. See Chapter 18, “Configuring Memory.”for more information.

The default data cache and all user-defined caches are explicitly configured with an absolute value. In addition, many configuration parameters use memory. To maximize performance and avoid errors, set the value of max memory to a level high enough to accommodate all caches and all configuration parameters that use memory.

Adaptive Server issues a warning message if you set max memory to a value less than total logical memory.