var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
UDB V8.2 FP7 OS . AIX 5.0
I am trying to improve the peformance of my system. I might need you help as i am not good in tuning.
1) I am seeing about 1650 transactions persecond. Do i need to increase the
value of Mincommit to some value . Currently it had the default values.
2) And i am seeing almost equal values for
Buffer pool data writes = 9075
Asynchronous pool data page writes = 8983
and Buffer pool index writes = 28892
Asynchronous pool index page writes = 28118
Is this a problem. As far as i know , both these values should not be same.
NO one has answers for it ?
I'm sure Administration Guide: Performance has all the answers you need.
In particular, increasing MINCOMMIT may be warranted in you case, if log write time is significant. You may need to increase log buffer as well.
As for asynchronous write operations, I'd say the more the better.
how did u find your total transaction
Can u tell me how did u find total transaction (1650) in your database per min or per sec ?
Greatly appreciate it.