To learn how to create a TPC-E 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-E Benchmark at: http://www.tpc.org/tpce/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-E like" test.
The following provides best practices for the TPC-E 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:
The TPC-E benchmark scales by factor of 500.
Review the following for information about the TPC-H benchmark.
To learn how to create a TPC-H 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-H Benchmark at: http://www.tpc.org/tpch/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-H like" test.
The following provides best practices for the TPC-H 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:
An option when creating a TPC-H workload is to include the TPC-H Stream Test, which is the multi-user version of the Power Test. The Steam Test, per specification, should maintain the following relationship between the scale factor and the number of Streams.
Scale Factor | Streams |
---|---|
1 | 2 |
10 | 3 |
30 | 4 |
100 | 5 |
300 | 6 |
1000 | 7 |
3000 | 8 |
10000 | 9 |
30000 | 10 |
The Replication benchmark test is a unique test developed by Benchmark Factory for testing replication in applications such as SharePlex.
This test allows you to create customized database objects, as well as a customized workload, in order to produce a repeatable database change rate and history (for example, Oracle redo logs) that can be used to test replication strategies. This test can also be used to create a model of your database and workload in order to help demonstrate replication performance.
While this benchmark was designed for testing and evaluating replication strategies and functionality in SharePlex, it can also be used to test other database replication products as well.
The following options can be customized in the Replication benchmark test:
See Create a Replication Benchmark Test to learn how to create a new Replication test.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center