The test results that I am
most interested in are tests of your Progress application.
It would be very interesting know what the
comparative key DB and OS performance metrics were showing during those test runs. For example:
MRP run #1, production
Parameters
Start time
Finish Time
PROMON, R&D Activity, Summary snapshot at beginning
PROMON, R&D Activity, Summary snapshot at end
PerfMon data, especially regarding disk IO operations, network traffic and CPU utilization
MRP run #1, test
Parameters
Start time
Finish Time
PROMON, R&D Activity, Summary snapshot at beginning
PROMON, R&D Activity, Summary snapshot at end
PerfMon data, especially regarding disk IO operations, network traffic and CPU utilization
The PROMON "Summary" screen looks like this:
Code:
04/15/11 Activity: Summary
18:07:04 01/29/11 12:46 to 04/15/11 18:03 (1828 hrs 16 min)
Event Total Per Sec |Event Total Per Sec
Commits 73637616 11.2 |DB Reads 3774282K 587.2
Undos 0 0.0 |DB Writes 1416067 0.2
Record Reads 34946876K 5437.1 |BI Reads 628831 0.1
Record Updates 494745 0.1 |BI Writes 3532748 0.5
Record Creates 48469096 7.4 |AI Writes 0 0.0
Record Deletes 0 0.0 |Checkpoints 1670 0.0
Record Locks 230211K 35.8 |Flushed at chkpt 163 0.0
Record Waits 19 0.0 |Active trans 0
Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 %
Writes by APW 70 % Writes by BIW 96 % Writes by AIW 0 %
DB Size: 41 GB BI Size: 64 MB AI Size: 0 K
Empty blocks: 10346 Free blocks: 609 RM chain: 19
Buffer Hits 94 % Primary Hits 94 % Alternate Hits 0 %
0 Servers, 5 Users (5 Local, 0 Remote, 5 Batch), 2 Apws
(Usually I tell people that I want "samples" during problem periods -- but in this case you are doing a controlled test so the math is easy enough.)
So if, for instance, the production run shows similar record activity but a very different number of "DB Reads" or "DB Writes" then it might be that the cache is busy being loaded (or it is configured with much less RAM on one server compared to the other). There are, of course, lots of other conclusions that can be drawn from other relationships -- that was just one example.