To learn how to create a TPC-B benchmark test in Benchmark Factory, see Create Industry Standard Benchmark Test.
The Transaction Processing Council is an organization that establishes transaction processing and database benchmark standards. Find a complete overview and detailed explanation of the TPC-B Benchmark, at: http://www.tpc.org/tpcb/default.asp
Transaction Processing Council testing results cannot be published as certified unless the testing procedure is audited and approved by the TPC organization. If not certified, the testing results can be published as a "TPC-B like" test.
The following provides best practices for the TPC-B Benchmark.
Do not load-test against a production server if possible. Load-testing and benchmarking on a production server significantly degrades performance. In some cases, load-testing can cause a server to fail. However, if testing against a production server, take the following precautions:
To reinitialize a testing database, run a job containing a Benchmark Object node.
There are two ways to create a Benchmark Object node:
The TPC-B benchmark is made up of only one transaction that updates three tables and inserts a record into a history table. Inserting one record into one history table limits testing performance. The Benchmark Factory properties page allows the user to set the number of history tables to create during a test. The best ratio of history tables to virtual users is based on database configuration and hardware. The number of history tables to use is determined by the tester.
The TPC-B benchmark scales by a factor of one.