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.
Today's 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. You'll 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. You'll learn to measure performance and
predict the specific impact of changes to your environment. You'll know
the limitations of the benchmarks and the crucial difference between
benchmarking and workload capture/reply.
This book teaches you how to create empirical evidence in support of
business and technology decisions. It's about not guessing when you
should be measuring. Empirical testing is scientific testing that
delivers measurable results. Begin with a hypothesis about the impact of
a possible architecture or technology change. Then run the appropriate
benchmarks to gather data and predict whether the change you're
exploring will be beneficial, and by what order of magnitude. Stop
guessing. Start measuring. Let Database Benchmarking and Stress
Testing show the way.
What You'll Learn
- Understand the industry-standard database benchmarks, and when each is
best used
- Prepare for a database benchmarking effort so reliable results can be
achieved
- Perform database benchmarking for consolidation, virtualization, and
cloud projects
- Recognize and avoid common mistakes in benchmarking database
performance
- Measure and interpret results in a rational, concise manner for
reliable comparisons
- Choose and provide advice on benchmarking tools based on their pros
and cons
**
Who This Book Is For
**
Database administrators and professionals responsible for advising on
architectural decisions such as whether to use cloud-based services,
whether to consolidate and containerize, and who must make
recommendations on storage or any other technology that impacts database
performance
