Sybase Adaptive Server Anywhere - A Database Performance and Connection Properties

Appendix A Database Performance and Connection Properties
1083
These statistics describe the use of the cache.
Statistic Scope Description
Cache Hits/sec Connection
Database
The rate at which database page lookups
are satisfied by finding the page in the
cache.
Cache Reads:
Index Interior
Connection
Database
The rate at which index internal-node
pages are read from the cache.
Cache Reads:
Index Leaf
Connection
Database
The rate at which index leaf pages are
read from the cache.
Cache Reads:
Table
Connection
Database
The rate at which table pages are read
from the cache.
Cache Reads:
Total
Connection
Database
The rate at which database pages are
looked up in the cache.
Cache Size:
Current
Engine The current size of the database server
cache, in kilobytes.
Cache Size:
Maximum
Engine The maximum allowed size of the
database server cache, in kilobytes.
Cache Size:
Minimum
Engine The minimum allowed size of the
database server cache, in kilobytes.
Cache Size: Peak Engine The peak size of the database server
cache, in kilobytes.
These statistics isolate the checkpoint and recovery actions performed when
the database is in an idle state.
Statistic Scope Description
Checkpoint
Flushes
Database The rate at which ranges of adjacent
pages are written out during a checkpoint.
Checkpoint Log Database The rate at which the transaction log is
checkpointed.
Checkpoint
Urgency
Database Checkpoint Urgency, expressed as a
percentage.
Checkpoints Database The rate at which checkpoints are
performed.
Idle Actives Database The rate at which the engine’s idle thread
becomes active to do idle writes, idle
checkpoints, etc.
Cache statistics
Checkpoint and
recovery statistics