Benchmarking for OLTP

Running an online transaction processing (OLTP) benchmark requires much planning and analysis. This section describes the procedures for developing a complete OLTP benchmark.

Designing tests

Design your performance benchmarking tests to reflect your application's production requirements and environment. Meaningful tests can take considerable time to design. This section provides information about the components of good test design and guidelines for designing meaningful tests:

• Setting goals
• Developing test scenarios
• Evaluating volume with production or synthetic data
• Determining workload
• Gathering metrics

Integrate your test components to ensure that the tests work well as a whole.