Database Benchmarking and Stress Testing

An Evidence-Based Approach to Decisions on Architecture and Technology

Nonfiction, Computers, Database Management, General Computing
Cover of the book Database Benchmarking and Stress Testing by Bert Scalzo, Apress
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Bert Scalzo ISBN: 9781484240083
Publisher: Apress Publication: October 8, 2018
Imprint: Apress Language: English
Author: Bert Scalzo
ISBN: 9781484240083
Publisher: Apress
Publication: October 8, 2018
Imprint: Apress
Language: English

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

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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: 

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

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

More books from Apress

Cover of the book Beginning JavaScript with DOM Scripting and Ajax by Bert Scalzo
Cover of the book Hibernate Recipes by Bert Scalzo
Cover of the book Complete Guide to Digital Project Management by Bert Scalzo
Cover of the book University Startups and Spin-Offs by Bert Scalzo
Cover of the book Pro PHP and jQuery by Bert Scalzo
Cover of the book HTML5 Game Development Insights by Bert Scalzo
Cover of the book Essentials of Administering Team Foundation Server 2015 by Bert Scalzo
Cover of the book The Pragmatist's Guide to Corporate Lean Strategy by Bert Scalzo
Cover of the book Beginning Oracle Database 12c Administration by Bert Scalzo
Cover of the book Deep Belief Nets in C++ and CUDA C: Volume 3 by Bert Scalzo
Cover of the book C++ Game Development Primer by Bert Scalzo
Cover of the book Audio Visualization Using ThMAD by Bert Scalzo
Cover of the book Pro ASP.NET Core MVC by Bert Scalzo
Cover of the book Microsoft Mapping by Bert Scalzo
Cover of the book Pro MERN Stack by Bert Scalzo
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy