Busy Buffer Waits
High Busy Buffer Waits is just an indication of a high write workload. No adjustment can be made to decrease this value.
Empty Buffer Waits
There are some adjustments that can be done to the database to decrease the BI empty buffer waits and will have a direct impact on the overall performance of the BI activity as well:
1. Start PROBIW (only possible when the Enterprise RDBMS license is installed).
2. If Empty Buffer Waits are noticed in promon, then increase -bibufs by setting the BI buffers during the startup of the database by using -bibufs.
Progress Documentation -> Manage the OpenEdge Database -> Managing PerformanceServer performance factors -> Before-image I/O -> Monitoring BI activity:
https://docs.progress.com/es-ES/bundle/openedge-database-management-122/page/Monitoring-BI-activity.html
Progress Documentation -> Manage the OpenEdge Database -> Database Startup Parameters -> Alphabetical listing of database startup parameters -> Before-image Buffers (-bibufs)
https://docs.progress.com/es-ES/bundle/openedge-database-management-122/page/Before-image-Buffers-bibufs.html
3. Increase the block size of the BI file, the default value is 8K and it can go to the maximum of 16KB.
4. Verify the interval between checkpoints and increase the size of the BI cluster if the checkpoint interval is less than 60 seconds.
The above are general recommendations and the results are very dependent on the number of users and the amount of activity within the database.
