Kbase P19894: How to decrease the bi busy buffer wait?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/26/2011 |
|
Status: Verified
GOAL:
How to decrease the BI busy buffer wait?
GOAL:
How to handle BI Log -> Busy Buffer Waits in promon?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
OpenEdge Category: Configuration
FIX:
There are some adjustments that can be done on the database to decrease the BI busy buffer waits and will have a direct impact on the overall performance on the BI activity as well:
1. Start PROBIW if the license used is an Enterprise Database version;
2. Provide enough BI buffers during the startup of the database by using ?bibufs. If you are seeing Busy Buffer Waits, then increase -bibufs.
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.
Those recommendations are general recommendations and the results depend on the activity of the database.