Kbase P166579: What is meant by the comment "keep writes/sec low. Reduce this number by increasing the AI buffer si
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/05/2010 |
|
Status: Unverified
GOAL:
What is meant by the comment "keep writes/sec low. Reduce this number by increasing the AI buffer size" as seen in the promon documentation of the AI activity page?
GOAL:
How to reduce the AI writes per second?
GOAL:
What is the location of the Ai Activity page in promon.
FACT(s) (Environment):
All Supported Operating Systems
Products / Versions
OpenEdge Category: Database
FIX:
The AI writes per sec are important in the sense of the max IO per sec to the disk drive where the after image files are located. If you max out the writes to disk it could be a bottleneck. Most modern drives can handle 150 sequential writes per second or more. If the sequential writes per second get too high you may need to increase the default ai buffer size from 8K to 16K so that you can write twice as much with each write, since the writes are done as a block unless a partial write is needed. That should cut the AI writes/sec in half. It is suggested that if the Ai blocksize is changed to 16K that the same change should be done for the bi block size. You can view the AI activity in Promon by running promon dbname/R&D/2/6.