Database Benchmarking and Stress Testing

An Evidence-Based Approach to Decisions on Architecture and Technology



Bookstore > Books > Database Benchmarking and Stress Testing

Price$23.76 - $29.99
Rating
AuthorBert Scalzo
PublisherApress
Published2018
Pages240
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484240073
ISBN-139781484240076
EBook Hardcover Paperback

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.

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.


  1. (2 books)



Similar Books


Oracle Database Performance and Scalability

Oracle Database Performance and Scalability

by Henry H. Liu

With database concepts and theories clearly explained in Oracle's context, readers quickly learn how to fully leverage Oracle's performance and scalability capabilities at every stage of designing and developing an Oracle-based enterprise application. The book is based on the author's more than ten years of experience working with Oracle,...

Price:  $85.98  |  Publisher:  Wiley  |  Release:  2011

Pro SQL Server 2012 Relational Database Design and Implementation

Pro SQL Server 2012 Relational Database Design and Implementation

by Louis Davidson, Jessica M. Moss

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a soli...

Price:  $50.93  |  Publisher:  Apress  |  Release:  2012

Oracle Database Transactions and Locking Revealed

Oracle Database Transactions and Locking Revealed

by Thomas Kyte, Darl Kuhn

Oracle Database Transactions and Locking Revealed provides much-needed information for building scalable, high-concurrency applications and deploy them against the Oracle Database. Read this short, 150-page book that is adapted from Expert Oracle Database Architecture to gain a solid and accurate understanding of how locking and concurren...

Price:  $34.99  |  Publisher:  Apress  |  Release:  2014

UX Optimization

UX Optimization

by William Tomlin

Combine two typically separate sources of data - behavioral quantitative data and usability testing qualitative data - into a powerful single tool that helps improve your organization's website by increasing conversion and ROI. The combination of the what is happening data of website activity, coupled with the why it's happening data of u...

Price:  $26.80  |  Publisher:  Apress  |  Release:  2018

Hands-On Microservices - Monitoring and Testing

Hands-On Microservices - Monitoring and Testing

by Dinesh Rajput

Microservices are the latest "right" way of developing web applications. Microservices architecture has been gaining momentum over the past few years, but once you've started down the microservices path, you need to test and optimize the services. This book focuses on exploring various testing, monitoring, and optimization techn...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2018

Next Generation Databases: NoSQL, NewSQL, and Big Data

Next Generation Databases: NoSQL, NewSQL, and Big Data

by Guy Harrison

This is a book for enterprise architects, database administrators, and developers who need to understand the latest developments in database technologies. It is the book to help you choose the correct database technology at a time when concepts such as Big Data, NoSQL and NewSQL are making what used to be an easy choice into a complex dec...

Price:  $38.44  |  Publisher:  Apress  |  Release:  2016

Managing the Testing Process, 3rd Edition

Managing the Testing Process, 3rd Edition

by Rex Black

In this new edition of his top-selling book, Rex Black walks you through the steps necessary to manage rigorous testing programs of hardware and software. The preeminent expert in his field, Mr. Black draws upon years of experience as president of both the International and American Software Testing Qualifications boards to offer this ext...

Price:  $3.00  |  Publisher:  Wiley  |  Release:  2009

Oracle DBA Checklists Pocket Reference

Oracle DBA Checklists Pocket Reference

by Quest Software

Oracle database administration is a complex and stressful job. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step-by-step "cookbook" approach to presenting DBA quick-reference material. The Oracle DBA Checklists...

Price:  $3.80  |  Publisher:  O'Reilly Media  |  Release:  2009