Hi gang,
I received this below from the architecture Dept. trying to simulate
Production like performance in QC and development envs. Assuming
performance testing would be equal in all those environments if buffers are
adjusted to a certain value. Please advise!
My question to you guys.
1- Can Buffer management be tuned mathematically as he stated without
examining the onstat -p, -B, -b and -X and #' of LRU's to determine
performance issues
Thanks!
" here is the architect reasoning below " Please send feedback , I need to
reply ASAP to them.
I have looked at Q buffer configuration vs, Production buffer
configuration.
Q 40000 buffers 256 peak session count ~80 average session count
P 200000 buffers 2816 peak session count ~2300 average session count
Using the average count this gives
500 buffers per session (buffers is actually a pool this number is for
relative comparisons of pool size)
87 buffers per session
As to table size I just looked at claim.
Q claim has 1000+ records
P claim has 95000+ records
To bring the two environments closer to per session pooling possibilities,
lower Q buffer pool to 7000. Also add data to CIS as was done to UWS.
The equivalent buffer change should be done in all of our development and
QC environments.
sending to informix-list