« My Electric Bike | Main | Some Different Electric Bikes »
April 27, 2009
Learning How to Swing Bench
Well, Dave and I have installed and configured Swing Bench on all of our f15 zones and on Slider. This is an application written by an Oracle guru in England that simulates a load on an Oracle db. You set up parameters such as number of users logged in, number of transactions, and the type of load. Then you run the "benchmark" to put a load on the db. You learn such things as how long it took the db to process the transactions, how many dml statements it ran, how many transactions failed. Let's look at a small example that shows how this is useful.
I set Swing Bench to log in 50 users and run 1,000 transactions. There are several Swing Bench modules, but we've installed one that simulates an online ordering business. So, it has areas such as "New Customer Registration", "Browse Products", "Order Products", "Process Orders", and "Browse Orders". You can adjust the percentage of each of these categories, but I just left them at their default values. OK, so it's all set up, let's run a benchmark on f15, z1, and dev db's. Here are some of the most useful results:
| Total TIme | Selects | Failures | Avg. Response | |
| f15 | 99 | 4370 | 0 | 136 |
| z1 | 92 | 4266 | 0 | 23 |
| dev | 65 | 3379 | 0 | 22 |
Now, here are some numbers from a run of 100 users, 5,000 transactions:
| Total TIme | Selects | Failures | Avg. Response | |
| f15 | 252 | 20683 | 38 | 153 |
| z1 | 217 | 21094 | 0 | 67 |
| dev | 84 | 3143 | 4098 | 22 |
Clearly, dev did not like the increased load from the second benchmark. My guess is, it's the higher number of users, but now we have the tool available to test this theory. Dave and I hope to use this to help us decide on optimum allocation of RAM, Hard drive resources, and swap for each of the containers.
Posted by rossm at April 27, 2009 10:05 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)