Overview
In an effort to provide foresight as systems grow and resources are stressed, this guidebook explains how one of the major causes of unplanned database outages is the failure to anticipate the effects of growth. The benchmark method detailed enables users to spot areas of pending problems before they cripple the database. This real-world approach ensures the user will be prepared for whatever the future brings to mission-critical databases. Areas explored in this book include knowing the limits of the database, avoiding unplanned outages with capacity planning, and predicting the need for new hardware.
Synopsis
In an effort to provide foresight as systems grow and resources are stressed, this guidebook explains how one of the major causes of unplanned database outages is the failure to anticipate the effects of growth. The benchmark method detailed enables users to spot areas of pending problems before they cripple the database. This real-world approach ensures the user will be prepared for whatever the future brings to mission-critical databases. Areas explored in this book include knowing the limits of the database, avoiding unplanned outages with capacity planning, and predicting the need for new hardware.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewAre you accountable for delivering database performance to committed service levels? Then you know how challenging it is to model user loads and predict database behavior. You can't hire 10,000 users to test your database. But you can get in-depth, in-the-trenches guidance from five leading database benchmarking experts. They're the authors of Database Benchmarking, a very practical and realistic book that doesn't shy away from the technical details.
This book covers all you need to know to effectively benchmark both Oracle and SQL Server. For instance: standard benchmarks and their limitations; capacity planning; and defining queries for measuring SLA compliance. You'll find detailed coverage of stress-testing specific workloads (such as OLTP), tasks (such as recovery), and specialized environments (such as distributed, consolidated, and virtualized systems).
Using this book, you can reduce risks and downtime, without throwing money at the problem. And that'll make your CIO very happy. Bill Camarda, from the April 2007 Read Only