Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Improving database performance » Performance Monitor statistics

 

Miscellaneous statistics

Statistic Scope Description
Avail IO Server Shows the current number of available I/O control blocks.
Connection Count Database Shows the number of connections to this database.
Main Heap Bytes Server Shows the number of bytes used for global database server data structures.
Query: Plan cache pages Connection and database Shows the number of pages used to cache execution plans.
Query: Low memory strategies Connection and database Shows the number of times the database server changed its execution plan during execution because of low memory conditions.
Query: Rows materialized/sec Connection and database Shows the rate at which rows are written to work tables during query processing.
Requests: GET DATA/sec Connection and database Shows the rate at which a connection is issuing GET DATA requests.
Temporary Table Pages Connection and database Shows the number of pages in the temporary file used for temporary tables.
Version Store Pages Database Shows the number of pages of the temporary file currently being used for the row version store when snapshot isolation is enabled.