Configuring Initial Cache Size on a Cluster for Performance

Configure the initial memory reserved for caching database pages on a cluster installation to enhance performance.

  1. Stop Unwired Server in each node.
    See Methods for Starting and Stopping Unwired Server.
  2. Stop the Cache DB service.
  3. Modify SMP_HOME\Servers\SQLAnywhere16\BIN64\cdboptions.ini as follows:
    Change -c 24M to -c 8G.
  4. Start the Cache DB service.
  5. Start Unwired Server in each node.
Parent topic: Cache Database Performance Tuning Reference