Database Benchmarking and Stress Testing: An Evidence-Based Approach to Decisions on Architecture and Technology (pdf)

$5.00

Author Bert Scalzo
Edition 1
Edition Year 2018
Format PDF
ISBN 9781484240076
Language English
Number Of Pages 262
Publisher Apress

Description

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

Additional information

Author

Bert Scalzo

Edition

1

Edition Year

2018

Format

PDF

ISBN

9781484240076

Language

English

Number Of Pages

262

Publisher

Apress

Reviews

There are no reviews yet.

Be the first to review “Database Benchmarking and Stress Testing: An Evidence-Based Approach to Decisions on Architecture and Technology (pdf)”

Your email address will not be published. Required fields are marked *