Database Stress Testing
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 the RPM’s can go before redlining. That does not mean that such testing is any less valuable, just that it basically serves a different testing purpose. For many people this is sufficient for what they might call database benchmarking.