You are here: System database > mpagecache
   |
   |
|
mpagecache
|
|
|
|
The dynamic mpagecache table provides information on the transaction log file of each server instance.
Table Columns
|
Name |
Type |
Description |
|
instance_id |
INTEGER |
Server instance. References sysinstances (id) |
|
free |
INTEGER |
Current number of free pages in the memory cache |
|
pinned |
INTEGER |
Current number of pages locked in memory, that cannot be page faulted, moved, etc. |
|
dirty |
INTEGER |
Current number of modified pages in the memory cache, unwritten to disk |
|
page_faults |
INTEGER |
Current rate of page faults (pages that have to be swapped out to disk so another can be swapped in) per second. |
|
checkpoint_pages_sec |
INTEGER |
Current rate of pages flushed to disk by transaction checkpoints per second |
|
checkpoint_group_pages |
INTEGER |
Current number of pages flushed to disk in a group, while a checkpoint is in progress. |
|
lwriter_pages_sec |
INTEGER |
Current rate of pages flushed by transaction checkpoints per second for the lazy-writer process |
|
lwriter_group_pages |
INTEGER |
Current number of pages flushed to disk in a group for the lazy-writer process. |
Related