?
* Swingbench
Swingbench is a free loadgenerator (and benchmarks) designed to stress test an Oracle database(9i,10g,11g).
?
* OpenLink ODBC Bench
OpenLink ODBC Bench is an open-sourceODBC Benchmarking tool providing real-time comparative benchmarking for ODBCDrivers, Database Engines, and Operating Systems combinations. The Benchmarks in thisapplication are loosely based on the TPC-A and TPC-C standard benchmarks, withmodifications to specifically test the performance of an ODBC Driver and/orDatabase Engine in a client/server environment.
?
* OpenLink JDBC Bench
Similar to OpenLink's ODBC Bench, this is a JDBC version.
?
* TPCC-UVa
A free, open-source implementation of the TPC-C Benchmark.
?
* Hammerora
An open source load generation tool.
?
?
2.5.2 Commercial Benchmark Kits
There are several industry standard benchmarks.
?
* Official Oracle Benchmark Kits
Similar to Microsoft and IBM, the official benchmark kits used byOracle can only be obtained under certain conditions. For more information,contact your Oracle Consulting/Partner/Support representative.
?
* Real Application Testing
While many wouldn't think of Real Application Testing asa traditional benchmark kit, it does perform workload execution primarily forthe real world benchmarking case.
?
* Quest Software'sBenchmark Factory for Databases
Benchmark Factory for Databases is aworkload simulation and scalability testing tool that stress tests yourenvironment by simulating users and transactions on the database. You caneither replay production workload or use synthetic workload to test the limitsof your database.
?
* SPEC jAppServer Benchmark Kit
This can be acquired directly from SPEC.
?
?
2.6 Benchmarking-related Books
There are several good books regarding benchmarking. The best I'vefound include the following:
?
* The Benchmark Handbook: For Database andTransaction Processing Systems (Jim Gray)
A great, albeit outdated book. While several of the benchmarks itdiscusses have been deprecated, it presents good concepts and backgroundinformation regarding benchmarking.
?
* Performance Analysis of Transaction ProcessingSystems (Wilbur H. Highleyman)
While out of print, this bookpresents both plain-text and math-heavy concepts of queueing and performanceanalysis techniques oriented for OLTP.
?
* Database Benchmarking: Practical Methods forOracle & SQL Server
?
This book explores all aspects of database benchmarking and showsyou a real-world approach that ensures that you are prepared forwhatever the future brings to your mission-critical database.