Try OpenEdge Now
skip to main content
Database Essentials
Database Administration : Daily monitoring tasks : Monitoring buffers flushed at checkpoint
 

Monitoring buffers flushed at checkpoint

Buffers flushed at checkpoint are a good indicator of APW and checkpoint efficiency. The APW's job is to keep writable buffers at a low count. You do not want frequent checkpoints where the database and memory are synchronized. If you are seeing an increase in buffers flushed during your prime operating times and they cannot be attributed to an online backup, then you need to make adjustments.