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_7

7. Benchmarking Software Options

Bert Scalzo¹ 

(1)

Flower Mound, TX, USA

 

The last chapter covered some hardware options important to review and consider changing when performing database benchmarking projects. While hardware advances the past decade have been nothing short of amazing (e.g., I just built a new desktop PC where the CPU offers 16 logical cores or threads), we cannot and should not always automatically look to hardware for solutions to performance issues. In reality, most benchmarking efforts can see the largest improvements to performance scores by leveraging appropriate new database features. The database vendors have likewise ...