P
post2manas
Guest
Hi Team We are facing slowness in the database and when checked there were frequent checkpoint in the database. Not sure how the checkpoint occur so frequently. We have optimized BI cluster size as well as 3 APWs. Details are below Progress Version 11.4 OS AIX DB Size 84GB DB Blocksize 8192 Before-image block size: 16384 bytes Before-image cluster size: 16384 kb Though there were no flush noted during checkpoint. Does this frequent checkpoint can slowdown DB performance? O/p from promon -> R&D -> 3. Other Displays ... -> 4. Checkpoints 10/05/17 Checkpoints 10:05:49 Ckpt ------ Database Writes ------ No. Time Len Freq Dirty CPT Q Scan APW Q Flushes Duration Sync Time 4745 10:05:46 3 0 74 106 1 0 0 2.17 2.12 4744 10:05:16 30 30 112 1924 27 1 0 0.63 0.56 4743 10:04:36 40 40 107 1794 71 1 0 3.09 2.93 4742 10:03:39 55 57 190 1615 123 13 0 4.49 4.28 4741 10:03:15 22 24 629 2356 21 3 0 4.54 1.84 4740 10:03:00 15 15 144 2014 9 0 1 2.05 1.60 4739 10:02:44 15 16 106 1731 17 1 0 1.70 1.61 4738 10:02:29 14 15 24 2220 3 2 0 1.75 1.54
Continue reading...
Continue reading...
