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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Improving database performance » Performance improvement tips


Acquire adequate hardware

When running on a PC, the following are the minimum CPU, memory, and disk requirements:

  • A minimum of 4 MB of memory. If you are using the administration tools, such as Sybase Central and Interactive SQL, a minimum of 48 MB of RAM is required.

  • Enough disk space to hold your database and log files.

If your server meets only the minimum hardware requirements, performance may suffer; you might want to upgrade your hardware. In general, evaluate the hardware configuration to see if it is adequate for the kind of work load being placed on the database server.

You can specify the -fc option when starting the database server to implement a callback function when the database server encounters a file system full condition.

For more information, see -fc server option.