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

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

 

Memory pages statistics

These statistics describe the amount and purpose of memory used by the database server.

Statistic Scope Description
Mem Pages: Lock Table Database Shows the number of pages used to store lock information.
Mem Pages: Locked Heap Server Shows the number of heap pages locked in the cache.
Mem Pages: Main Heap Server Shows the number of pages used for global database server data structures.
Mem Pages: Map Pages Database Shows the number of map pages used for accessing the lock table, frequency table, and table layout.
Mem Pages: Procedure Definitions Database Shows the number of relocatable heap pages used for procedures.
Mem Pages: Relocatable Database Shows the number of pages used for relocatable heaps (cursors, statements, procedures, triggers, views, and so on).
Mem Pages: Relocations/sec Database Shows the rate at which relocatable heap pages are read from the temporary file.
Mem Pages: Rollback Log Connection and database Shows the number of pages in the rollback log.
Mem Pages: Trigger Definitions Database Shows the number of relocatable heap pages used for triggers.
Mem Pages: View Definitions Database Shows the number of relocatable heap pages used for views.