Sybase Adaptive Server Anywhere - Page 1106

Database performance statistics
1088
Statistic Scope Description
JVM:
Global Fixed Size
Server The total bytes allocated to the Java VM
fixed heap.
JVM:
Heap Size
Connection
Database
The total bytes allocated to connection
Java VMs
JVM:
Namespace size
Database The total number of bytes allocated to the
Java VM namespace.
These statistics describe the amount and purpose of memory used by the
database server.
Statistic Scope Description
Mem Pages:
Locked Heap
Server The number of heap pages locked in the
cache.
Mem Pages:
Lock Table
Database The number of pages used to store lock
information.
Mem Pages:
Rollback Log
Connection
Database
The number of pages in the rollback log.
Mem Pages:
Main Heap
Server The number of pages used for global
engine data structures.
Mem Pages:
Map Pages
Database The number of map pages used for
accessing the lock table, frequency table,
and table layout.
Mem Pages:
Procedure
Definitions
Database The number of relocatable heap pages
used for procedures.
Mem Pages:
Relocatable
Database The number of pages used for relocatable
heaps (cursors, statements, procedures,
triggers, views, etc.).
Mem Pages:
Relocations
Database The rate at which relocatable heap pages
are read from the temporary file.
Mem Pages:
Trigger Definitions
Database The number of relocatable heap pages
used for triggers.
Mem Pages:
View Definitions
Database The number of relocatable heap pages
used for views.
These statistics describe the database server activity devoted to responding to
requests from client applications.
Memory pages
statistics
Request statistics