These statistics describe the use of the cache.
| Statistic | Scope | Description |
|---|---|---|
| Cache Hits/sec | Connection and database | Shows the rate at which database page lookups are satisfied by finding the page in the cache. |
| Cache Reads: Index Interior/sec | Connection and database | Shows the rate at which index internal-node pages are read from the cache. |
| Cache Reads: Index Leaf/sec | Connection and database | Shows the rate at which index leaf pages are read from the cache. |
| Cache Reads: Table/sec | Connection and database | Shows the rate at which table pages are read from the cache. |
| Cache Reads: Total Pages/sec | Connection and database | Shows the rate at which database pages are looked up in the cache. |
| Cache Reads: Work Table | Connection and database | Shows the rate at which work table pages are being read from the cache. |
| Cache Replacements: Total Pages/sec | Server | Shows the rate at which database pages are being purged from the cache to make room for another page that is needed. |
| Cache Size: Current | Server | Shows the current size of the database server cache, in kilobytes. |
| Cache Size: Maximum | Server | Shows the maximum allowed size of the database server cache, in kilobytes. |
| Cache Size: Minimum | Server | Shows the minimum allowed size of the database server cache, in kilobytes. |
| Cache Size: Peak | Server | Shows the peak size of the database server cache, in kilobytes. |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |