7. Generating Time Profiles

7. Generating Time Profiles

In addition to performance profiles based on throughput you should also take note of transaction response times. Whereas performance profiles show the cumulative performance of all of the virtual users running on the system, response times show performance based on the experience of the individual user. When comparing systems both throughput and response time are important comparative measurements. HammerDB includes a time profiling package called etprof that enables you to select an individual user and measure the response times.

Vuser 1:57 Virtual Users configured
Vuser 1:TEST RESULT : System achieved 33214871 MySQL TPM at 508090 NOPM
Vuser 2:+-----------------+--------------+------+--------+--------------+--------------+
Vuser 2:|PROCNAME | EXCLUSIVETOT| %| CALLNUM| AVGPERCALL| CUMULTOT|
Vuser 2:+-----------------+--------------+------+--------+--------------+--------------+
Vuser 2:|neword | 231135249|57.60%| 62703| 3686| 235869271|
Vuser 2:|payment | 78117692|19.47%| 62798| 1243| 82855895|
Vuser 2:|delivery | 66664275|16.61%| 6227| 10705| 67134377|
Vuser 2:|slev | 16970776| 4.23%| 6260| 2710| 16976558|
Vuser 2:|ostat | 6827796| 1.70%| 6396| 1067| 6833752|
Vuser 2:|gettimestamp | 1570148| 0.39%| 131728| 11| 9323129|
Vuser 2:|TOPLEVEL | 1827| 0.00%| 1| 1827| NOT AVAILABLE|

The output from etprof taken from each system should be used in context with the overall performance profile to break down the overall system throughput to the timing of the individual transactions themselves and then graphed to show the comparison.

Figure 3.4. Response Times

Response Times