A fewer minor patches to both swingbench 2.2 and 2.3 including

• Faster orderentry schema build
• Fix in the 2.2 oewizard where users where unable to specify the size of the schema

you can download the new builds here

I've updated 2.3 (I told you I'd be patching regularly) to include new command line functionality for charbench and a few fixes to some of the benchmarks.

I've replaced the old command line options of -vc,-vt, etc. with a more flexible option. you can now choose to list as many or as few metrics as you desire.

./charbench -v users,tpm,tps,cpu,disk,dml

Displays the time of the reading, users logged on, transactions per minute, transactions per second, cpu, disk, and dml operations. Adding the -rr option (refresh rate) allows you t change the speed of update.

./charbench -v users,tpm,tps,cpu,disk,dml -rr 1

Will update the reading every second.

It can be downloaded from the usual location.

So I've finally got enough of swingbench 2.3 finished to feel confident I can at least show you where I am There's just one or two things I need to include before I can feel confident that I can take it out of beta. But before I tell you what those are let me tell you what's new.

• Updated GUI to include all configuration parameters

• New overview chart including all relevant info (see below)

• Numerous bug fixes
• Changes to configuration file (Sorry!!)
• Some new command line parameters for charbench

I've still got a few things to finish, these include
• Frequency support for transactions i.e run once every 20 minutes
• Statistic collection window.

So expect more frequent releases over the next few days.

Like always you can get the latest build here

I'll be doing a webcast on swingbench to the US RAC SIG on June 4th. I believe it will be starting at 9.30 PT (check the web sit for confirmation). I hope to detail what swingbench is capable of, the best practices when using swingbench and what I'll be doing next. I think Im suppose to be answering questions as well so you'll get a chance to have ago at me for all those annoying bugs....

So if your interested join in and I'll do my best to keep it informative and entertaining.

Dom.

I've backported some functionality from 2.3 to 2.2. This enables the user to specify the runtime for swingbench from the command line. I've also added a new command line option to specify a login delay from the command line as well. This is useful for throttling back connections for large numbers of sessions.

ie.

./charbench -cs //kgy11034/orcl -rt 0:30 -a -uc 1000 -min 1500 -max 2500 -ld 10

Will run charbench for 30 minutes and then automatically log off the users... the -ld 10 will put a 10 millisecond delay in between connections giving the server a bit of breathing space...

you should be able to run all tests using a script like this

./charbench -cs //kgy11034/orcl -rt 0:30 -a -uc 1000 -min 1500 -max 2500 -ld 10
./charbench -cs //kgy11034/orcl -rt 0:30 -a -uc 2000 -min 1500 -max 2500 -ld 10
./charbench -cs //kgy11034/orcl -rt 0:30 -a -uc 3000 -min 1500 -max 2500 -ld 10
./charbench -cs //kgy11034/orcl -rt 0:30 -a -uc 4000 -min 1500 -max 2500 -ld 10

I've also recompiled 2.2 with a 1.4 JVM to support backwards compatibility.

Its not easy keeping an idea on all aspects of swingbench and sometimes I let stuff get through that really shouldn't. I try my best. I made a amateurish mistake on sequence numbers in the order entry bench. I've uploaded a new build of 2.2 which I'll include in the new 2.3 build shortly. If you find these annoying little bugs or potentially big issues drop me a line and I'll do my best to put it right.