Appendix A Database Performance and Connection Properties
1089
Statistic Scope Description
Requests Server The rate at which the engine is entered to
allow it to handle a new request or
continue processing an existing request.
Requests:
Active
Server The number of engine threads currently
handling a request.
Requests:
Unscheduled
Server The number of requests are currently
queued up waiting for an available engine
thread.
Cursors Connection The number of declared cursors currently
maintained by the engine.
Cursors Open Connection The number of open cursors currently
maintained by the engine.
Statements Connection The number of prepared statements the
engine currently maintains.
Statement Prepares Connection The rate at which statement prepares are
being handled by the engine.
Transaction
Commits
Connection The rate at which Commit requests are
handled.
Transaction
Rollbacks
Connection The rate at which Rollback requests are
handled.
Statistic Scope Description
Avail I/O Server Expressed as a count.
Context Switches Connection The rate at which the current engine
thread changes.
Main Heap Bytes Server The number of bytes used for global
engine data structures.
Request Queue
Waits
Server The rate at which the engine must wait
for room in the request queue.
Miscellaneous
statistics