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_12

12. Database Stress Testing

Bert Scalzo¹ 

(1)

Flower Mound, TX, USA

 

In this final chapter, we’re going to discuss simple database stress testing, plus present a free scripting tool that I’ve written for people to utilize or alter to fit their specific needs. A stress test is much like an industry-standard benchmark in that it attempts to press the database. It’s quite different as it applies simple, atomic transactions to merely stress the underlying subsystems, especially the IO bandwidth. I think of stress testing as being more like “gunning the engine” of an automobile, where the car is in neutral and you just want to see how high ...