Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Tips for improving performance » Tip: Use the cache to improve performance


Dynamic cache sizing

You can use SQL Anywhere to automatically resize the database cache while the database server is running. With full dynamic cache sizing, the cache grows when more memory is made available to the database server and shrinks when cache memory is required by other applications. The effectiveness of dynamic cache sizing varies depending on the operating system and the amount of available physical memory.

Typically, the cache requirements are assessed by dynamic cache sizing once per minute. However, when a new database is started or when a file grows significantly, the assessment frequency may increase to once every five seconds for thirty seconds. After the initial thirty second period, the assessment frequency returns to once per minute. File growth is considered significant if it is one eighth greater than the last growth that triggered an increase in the assessment frequency or one eighth greater than when the database started.

With dynamic cache sizing you do not need to explicitly configure the database cache.

If you attempt to set your initial or minimum cache sizes to a value that is less than one eighth of the maximum cache size, the initial and minimum cache sizes are automatically increased by an amount computed from the maximum cache size.

 See also

Dynamic cache sizing on Windows
Dynamic cache sizing on Unix