Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Database Benchmarking and Stress Testing: An Evidence-Based Approach to Decisions on Architecture and Technology

Buy
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

(HTML tags aren't allowed.)

Oracle PL/SQL for DBAs
Oracle PL/SQL for DBAs

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between...

OCP: Oracle 10g New Features for Administrators Study Guide : Exam 1Z0-040 (Certification Study Guide)
OCP: Oracle 10g New Features for Administrators Study Guide : Exam 1Z0-040 (Certification Study Guide)

Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of...

Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)
Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL,...


Portable DBA: Oracle
Portable DBA: Oracle
This handy, affordable reference is ideal for on-the-job DBAs in need of quick access to administrative commands, error resolutions, and best practices. Covering the most commonly used Oracle database versions, the book contains invaluable tables so problems can be diagnosed quickly and includes examples and syntax diagrams for each command. ...
High Performance MySQL: Optimization, Backups, and Replication
High Performance MySQL: Optimization, Backups, and Replication
We wrote this book to serve the needs of not just the MySQL application developer but also the MySQL database administrator. We assume that you are already relatively experienced with MySQL. We also assume some experience with general system administration, networking, and Unix-like operating systems.

The second edition of
...
Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases
Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases

EXAM PREP GUIDE

Ace your preparation for the skills measured by Exam 70-462—and on the job—with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through
...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy