These statistics describe the database server activity devoted to responding to requests from client applications.
| Statistic | Scope | Description |
|---|---|---|
| Cursors | Connection | Shows the number of declared cursors currently maintained by the database server. |
| Cursors Open | Connection | Shows the number of open cursors currently maintained by the database server. |
| Lock Count | Connection and database | Shows the number of locks. |
| Requests/sec | Server | Shows the rate at which the database server is entered to allow it to handle a new request or continue processing an existing request. |
| Requests: Active | Server | Shows the number of database server threads that are currently handling a request. |
| Tasks: Exchange | Server | Shows the number of database server threads that are currently being used for parallel execution of a query. |
| Requests: Unscheduled | Server | Shows the number of requests that are currently queued up waiting for an available database server thread. |
| Snapshot Count | Connection and database | Shows the number of active snapshots. |
| Statement Cache Hits | Connection and server | Shows the rate at which statement prepares cached by the client are being re-used by the database server. |
| Statement Cache Misses | Connection and server | Shows the rate at which statement prepares cached by the client need to be prepared again by the database server. |
| Statement Prepares | Connection and database | Shows the rate at which statement prepares are being handled by the database server. |
| Statements | Connection | Shows the number of prepared statements currently maintained by the database server. |
| Transaction Commits | Connection | Shows the rate at which Commit requests are handled. |
| Transaction Rollbacks | Connection | Shows the rate at which Rollback requests are handled. |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |