Kbase P105360: How to best size the Database Buffer Pool
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to best size the Database Buffer Pool
GOAL:
How to tune -B server startup parameter
FIX:
While having started the database server with a certain value for -B (proserve <db> -B <value>), you may want to check if you do have the best value as the size of the Database Buffer Pool.
The optimal value for -B is the minimum value achieving the maximal buffer hits. The application will perform better when:
. as less as possible memory is reserved for the Database Buffer Pool.
. the less as possible I/O's are made when reading data.
Testing is the only way to know the optimal value.
Stop and restart of the database server is needed for changing the buffer pool size. The buffer hits percentage is displayed from promon's activity screen.