ISBN 0-9776715-3-4 ISBN 13 978-0977671533 Library of Congress Number: 2006931339 200 pages Perfect bind - 9x7 PD 107 Shelving: Database/Oracle IT in-Focus: Series # 3

Database Benchmarking Practical methods for Oracle & SQL Server Dr. Bert Scalzo, Kevin Kline, Claudia Fernandez Donald K. Burleson, Mike Ault Retail Price $39.95 / £27.95 Key Features About the Authors Table of Contents Index     Only $27.95

Every information system must know their limits. As systems grow, resources are stressed and one of the major causes of unplanned database outages is a failure to anticipate the effects of growth. Benchmarking is a critical job function and every database professional must understand the principles of capacity planning and database bottleneck analysis. By using a benchmark method you can spot areas of pending problems before they cripple your database. This landmark book explores all aspects of database benchmarking and shows you a real-world approach that ensures that you are prepared for whatever the future brings to your mission-critical database.

* Know the limits of your database before you hit them * Avoid unplanned outages with capacity planning * Learn the exact limits of your transaction rates * Predict when you will need new hardware

About the Authors:

Donald Burleson	Donald K. Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience. He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems. A former Adjunct Professor, Don Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.
Mike Ault	Mike Ault has five Oracle Masters Certificates. Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.
Bert Scalzo, Ph.D.	Dr. Bert Scalzo is a Database Architect for Quest Software and a member of the TOAD team. Mr. Scalzo has worked with Oracle databases for well over two decades, starting with version 4. His work history includes time at Oracle Education and Oracle Consulting, plus he holds several Oracle Masters certifications. Mr. Scalzo also has an extensive academic background - including a BS, MS and PhD in Computer Science, an MBA and several insurance industry designations. Mr. Scalzo is an accomplished speaker and has presented at numerous Oracle conferences and user groups - including OOW, ODTUG, IOUGA, OAUG, RMOUG, et al. His key areas of DBA interest are Data Modeling, Database Benchmarking, Database Tuning & Optimization, "Star Schema" Data Warehouses and Linux. Mr. Scalzo has written articles for Oracle’s Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell PowerEdge Magazine, The Linux Journal, www.linux.com, and www.orafaq.com. He also has written four books: "Oracle DBA Guide to Data Warehousing and Star Schemas", "TOAD Handbook", "TOAD Pocket Reference" (2nd Edition), "Database Benchmarking: Practical methods for Oracle 10g & SQL Server 2005", "Oracle on VMware: Expert Tips for Database Virtualization, and "Advanced Oracle Utilities: The Definitive Reference".
Kevin Kline	Kevin Kline is the director of technology for SQL Server Solutions at Quest Software and president of the international Professional Association for SQL Server (PASS) and frequently contributes to database technology magazines, Web sites, and discussion forums. Kevin is the author of "SQL in a Nutshell" (O'Reilly & Associates), "Transact-SQL Programming," and several other books about database technologies. Kevin is a top-rated speaker, appearing at international conferences including Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Server Magazine Connections.
Claudia Fernandez	Claudia Fernandez is a Product Manager of SQL Tuning products at Quest Software. Claudia has contributed to the strategic direction of SQL tuning products for multiple RDBMS since early 2000. She has presented at several technical conferences on RDBMS and Application Performance Tuning topics. Claudia holds a MS in Computer Science and has several years of industry experience working with SQL Server, Sybase ASE, Oracle, DB2 UDB and other associated technologies. She enjoys movies and traveling.

Table of Contents:

Using the Online Code Depot Supplemental Materials Conventions Used in this Book Acknowledgements Preface Database Predictive Analysis Database Benchmark Validity The Problems of Adaptive Threshold Forecasting Predictive Modeling in the Real-world Databases that Benefit from Predictive Analysis The Transaction Processing Performance Council Benchmarking Bi-modal Databases Capacity Planning and Performance Testing Forecasting the Future Database Benchmarking Myths Learning from Database Benchmarks Conclusion Database Benchmarking Industry Standard Benchmarks Basic Benchmark Components Specifications Details Design Goals Data Points Test Plan Control Logic Repeatability Accurate Statistics Database Benchmarks with Benchmark Factory TPC-C TPC-H TPC-E ASAP and Scalable Hardware Benchmarking with a Custom Workload Conclusion Introduction Trend Identification with Benchmark Tools Testing a Suggested Architecture System Information Database Objects Details of Materialized View Transaction Details Insert Transaction Select Transaction Phase : Both Insert and Select Varying Phase : SELECT Transaction Level Constant Concurrent SELECTS Concurrent SELECTS Concurrent SELECTS Phase : Materialized View with No Partitions

Combined Results Combined Results Summary Recommendations Planning Future Hardware & Software Needs Architecture Executive Summary Limitations and Caveats Phase : Issues Query Testing Randomization of the Issues Queries Transaction Times for Issues Tests Average Transaction Times Database Activity Operating System Activity Phase Conclusion Maintaining Service Level Agreements (SLA’s) Determining SLA Test Queries Ok here is the SLA and Queries What Now? Issues with Generating Your Own Scripts The Easy Way Supporting Server & Storage Consolidations Database Implosion Therapy Hardware Issues in Stress Testing Configuring the Server Environment Stress Testing Specific Workloads Stressing Read-Only Databases (Read-only Implosion) Stressing OLTP Databases (DML Implosion) Stressing Mixed Databases (General Implosion) Stressing Specialized Environments Stressing Distributed Systems Stressing Consolidated Systems Stressing Virtualized Systems Stressing Specific Database Platforms Not all SQL Implementations up to Spec Not all Query Optimizers Created Equal Conclusion Isolate the Benchmark Environment Prepare the Server Operating System Windows Linux Prepare the Database Configuration SQL Server Oracle Concentrate on What and not How Installing Benchmark Factory Conclusion Selecting among Benchmarks Creating Benchmark Jobs Running Benchmark Jobs Monitoring Benchmark Runs Special Oracle RAC Considerations Conclusion Don’t Rush to Conclusions An Example on Oracle An Example on Microsoft SQL Server Finding the “Sweet Spot” When Conclusions are not Self-Evident Correlating Results Real-time versus “Run” Reports Extrapolation & Interpolation Documenting the Final Analysis

Index Topics: