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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and improving database performance » Improving database performance » Performance improvement tips


Monitoring cache size

The following statistics are included in the Windows Performance Monitor and the database's property functions.

  • CurrentCacheSize   The current cache size in kilobytes

  • MinCacheSize   The minimum allowed cache size in kilobytes

  • MaxCacheSize   The maximum allowed cache size in kilobytes

  • PeakCacheSize   The peak cache size in kilobytes

For more information about these properties, see Database server properties.

For information about monitoring performance, see Monitoring database performance.