Feedback
Did this article resolve your question/issue?

   

Article

How to decrease Buffers Flushed?

Information

 
TitleHow to decrease Buffers Flushed?
URL NameP41970
Article Number000147708
EnvironmentProduct: Progress OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
How to decrease Buffers Flushed (PROMON Activity or _ActBuffer._Buffer-Flushed VST)?
When should I use more APWs?
Steps to Reproduce
Clarifying Information
PROMON > 5.  Activity

Event                 Total   Per Sec   Event                 Total   Per Sec
       Commits    1,871,989        13          Undos          1,128         0
Record Updates    1,970,778        14   Record Reads    551,394,617     3,893
Record Creates    2,818,960        20 Record Deletes      4,495,568        32
     DB Writes    1,871,872        13       DB Reads    194,533,556     1,373
     BI Writes      775,827         6       BI Reads         73,278         1
     AI Writes      532,784         4
  Record Locks   45,121,528       319   Record Waits           2116         1
   Checkpoints          122         0  Buffs Flushed         59,181        23

Rec Lock Waits      0   BI Buf Waits      0 %    AI Buf Waits      0 %
Writes by APW       1   Writes by BIW     1 %    Writes by AIW     1 %
Buffer Hits         1   Primary Hits     74 %    Alternate Hits    0 %
DB Size        878 GB        BI Size  1023 MB        AI Size     128 K
FR chain              1739223 blocks  RM chain        77672987  blocks
Shared Memory  7392M        Segments      1

1 Servers, 125 Users,1 Apws


Buffers Flushed metrics are found in several PROMON views:
  • promon -> 5. Activity    "Buffs Flushed"
  • promon -> R&D -> 2. Activity Displays -> 1. Summary       "Flushed at chkpt"
  • promon -> R&D -> 2. Activity Displays -> 4. Page Writers  "Flushed at checkpoint"
  • promon -> R&D -> 3. Other Displays   -> 4. Checkpoints.  (per individual checkpont)
Error Message
Defect/Enhancement Number
Cause
Resolution
With an Enterprise database license, start an additional APW. 
As general rule of thumb, if the number of buffers flushed is higher than 10, increase the bicluster size, increase the number of page writers, or increase disk write capacity. For further advice refer to Article: With a Workgroup or Personal database license, since APWs are not available increasing the BI Cluster size would likely increase the duration of the checkpoints further as the first process that needed to move to a new BI cluster would first have to write all database buffers that were referenced in the BI cluster. Consider upgrading to an Enterprise Database License if performance is a priority.
Workaround
Notes
Last Modified Date8/27/2019 2:16 PM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.