Hi,
Plafform:
SUN solaris 7 512MB, 400Mhz x 2
Progress 8.3d enterprise
I do not have the knowledge if my database is performing well, we did experience some slowness but I do not know where/how to tune it.
below is my sample:
ctivity - Sampled at 04/16/01 09:40 for 0:35:12.
Event Total Per Sec Event Total Per Sec
Commits 98470 46.6 Undos 11 0.0
Record Updates 109030 51.6 Record Reads 1694336 802.2
Record Creates 113165 53.5 Record Deletes 112972 53.4
DB Writes 74189 35.1 DB Reads 123102 58.2
BI Writes 16089 7.6 BI Reads 748 0.3
AI Writes 0 0.0
Record Locks 1863260 882.2 Record Waits 1 0.0
Checkpoints 231 0.1 Buffers Flushed 73796 34.9
Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 %
Writes by APW 0 % Writes by BIW 0 % Writes by AIW 0 %
Buffer Hits 97 %
DB Size 1081216 K BI Size 10752 K AI Size 0 K
FR chain 0 blocks RM chain 292 blocks
Shared Memory 42000 K Segments 3
I believe my -B which is set to -B 5000 (8k blksize) is quite ok as my Buffer hits is often 95 - 97 %.
However I feel that my checkpoints is quite high and my commits is low. I also measure my cpu rate using "sar" and the cpu idle time is high.
Does anyone has comments on the above?
thanks in advance.
Plafform:
SUN solaris 7 512MB, 400Mhz x 2
Progress 8.3d enterprise
I do not have the knowledge if my database is performing well, we did experience some slowness but I do not know where/how to tune it.
below is my sample:
ctivity - Sampled at 04/16/01 09:40 for 0:35:12.
Event Total Per Sec Event Total Per Sec
Commits 98470 46.6 Undos 11 0.0
Record Updates 109030 51.6 Record Reads 1694336 802.2
Record Creates 113165 53.5 Record Deletes 112972 53.4
DB Writes 74189 35.1 DB Reads 123102 58.2
BI Writes 16089 7.6 BI Reads 748 0.3
AI Writes 0 0.0
Record Locks 1863260 882.2 Record Waits 1 0.0
Checkpoints 231 0.1 Buffers Flushed 73796 34.9
Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 %
Writes by APW 0 % Writes by BIW 0 % Writes by AIW 0 %
Buffer Hits 97 %
DB Size 1081216 K BI Size 10752 K AI Size 0 K
FR chain 0 blocks RM chain 292 blocks
Shared Memory 42000 K Segments 3
I believe my -B which is set to -B 5000 (8k blksize) is quite ok as my Buffer hits is often 95 - 97 %.
However I feel that my checkpoints is quite high and my commits is low. I also measure my cpu rate using "sar" and the cpu idle time is high.
Does anyone has comments on the above?
thanks in advance.