C
ChUIMonster
Guest
On 8/29/14, 2:59 PM, bluelinebrotha wrote: RE: What is the best configuration for OE 10.2B Database? Reply by bluelinebrotha Fri Aug 29 03:18:37 2014 31,930 [ 2014/08/29@03:18:37.399-0400 ] P-3556 T-3416 I BROKER 0: (333) Multi-user session begin. 31,949 [ 2014/08/29@03:18:40.085-0400 ] P-3556 T-3416 I BROKER 0: (4239) Number of Database Buffers (-B): 250000. Kind of small, just 1GB of cache (I see 4k db blocks later on...). But probably not related to slow commits. 31,957 [ 2014/08/29@03:18:40.092-0400 ] P-3556 T-3416 I BROKER 0: (4243) Current Spin Lock Tries (-spin): 1. A "Workgroup" database? If true that is probably the fundamental problem. Slow commits are the trade-off that you make for cheap licenses. If false and the license is actually "Enterprise" then start a BIW and an APW and set -spin 5000. 31,965 [ 2014/08/29@03:18:40.097-0400 ] P-3556 T-3416 I BROKER 0: (4250) Before-Image Cluster Size: 524288. The default bi cluster size -- if this is, indeed, a workgroup database try making it smaller. Maybe 128k. That will result in more frequent, but shorter, pauses when committing transactions. If it is Enterprise make it larger. 16384 is "a good start" (if and only if it is an enterprise license). 31,978 [ 2014/08/29@03:18:40.108-0400 ] P-3556 T-3416 I BROKER 0: (-----) Server network message wait time (-Nmsgwait): 2 31,979 [ 2014/08/29@03:18:40.109-0400 ] P-3556 T-3416 I BROKER 0: (-----) Delay first prefetch message (-prefetchDelay): Disabled 31,980 [ 2014/08/29@03:18:40.110-0400 ] P-3556 T-3416 I BROKER 0: (-----) Prefetch message fill percentage (-prefetchFactor): 0 31,981 [ 2014/08/29@03:18:40.110-0400 ] P-3556 T-3416 I BROKER 0: (-----) Minimum records in prefetch ms (-prefetchNumRecs): 16 31,982 [ 2014/08/29@03:18:40.111-0400
Continue reading...
Continue reading...
