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

 

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

Note

The Windows Performance Monitor is available on Windows.

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

For information about monitoring performance, see Monitoring database performance.