Provide evidence-based answers that can be measured and relied upon by your business. Database administrators will be able to make sound architectural decisions in a fast-changing landscape of virtualized servers and container-based solutions based on the empirical method presented in this book for answering what if questions about database performance.
Todays database administrators face numerous questions such as:
- What if we consolidate databases using multitenant features?
- What if we virtualize database servers as Docker containers?
- What if we deploy the latest in NVMe flash disks to speed up IO access?
- Do features such as compression, partitioning, and in-memory OLTP earn back their price?
- What if we move our databases to the cloud?
As an administrator, do you know the answers or even how to test the assumptions?
Database Benchmarking and Stress Testing introduces you to database benchmarking using industry-standard test suites such as the TCP series of benchmarks, which are the same benchmarks that vendors rely upon. Youll learn to run these industry-standard benchmarks and collect results to use in answering questions about the performance impact of architectural changes, technology changes, and even down to the brand of database software. Youll learn to measure performance and predict the specific impact of changes to your environment. Youll know the limitations of the benchmarks and the crucial difference between benchmarking and workload capture/reply.
This book teaches you how to ls.