THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Wiki Markup |
|---|
attachment:perf-excel2.png [BR] As a software tester, sometimes you are called upon to performance test a web service (see \[:../UserManual/BuildWSTest:BuildWSTest\]) and present results in a nice chart to impress your manager. JMeter is commonly used to thrash the server and produce insane amounts of throughput data. If you're running 1000 tpm this can be rather a lot of data (180,000 transactions for a 3 hour test run). Even using the *Simple Data Writer*, this is beyond the capability of JMeter's inbuilt graphics package and is too much to import to Excel. |
My solution is to group throughput per minute and average transaction time for each minute. Attached below is a Bash script for processing a JTL log file from JMeter. It reduces a 3-hour test run to 180 data points which is much easier to represent with a chart program such as Excel. BR The script uses a few neat awk tricks, such as:
BR
...