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 Monitor statistics

 

Request statistics

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.