Database Benchmarking and Stress Testing: An Evidence-Based Approach to Decisions on Architecture and Technology

© Bert Scalzo 2018

Bert ScalzoDatabase Benchmarking and Stress Testinghttps://doi.org/10.1007/978-1-4842-4008-3_2

2. Industry Standard Benchmarks

Bert Scalzo¹ 

(1)

Flower Mound, TX, USA

 

In Chapter 1 we differentiated between a database benchmark, database stress test, and workload capture/replay. By understanding these differing approaches, we formed the foundation for a common understanding and vocabulary. Plus we learned why these different techniques are useful and when to best utilize them. To recap, our basic definitions were:

• A database stress test is an indefinite and limited in nature, artificial workload meant to basically stress the database’s low-level performance (i.e., to make the database sweat).

• A database benchmark is a well-defined ...