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 - Database Administration » Database maintenance » Troubleshooting SQL Anywhere database issues » Troubleshooting database server performance warnings


Performance warning: Server cache size is too small for database %1

This warning is reported if the database server's maximum cache size (the upper limit of the database server's buffer pool size, as computed by the server or as explicitly specified by the -ch option) is less than 10% of the total size of all the open dbspaces for a database.

For example, a database server hosting a 21 GB database would issue this warning if the server's maximum cache size was less than 2.1 GB. This warning is computed on a per-database basis, and may not be issued even if multiple databases are started on the same database server.

 See also