Database Benchmarking: Practical Methods for Oracle & SQL Server

Front Cover
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.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Mike Ault
1
Databases that Benefit from Predictive Analysis
11
Database Benchmarking
17
TPCC
24
TPCH
31
Introduction
37
Both Insert and Select Varying
45
Materialized View with No Partitions
58
Conclusion
89
Stress Testing Specific Workloads
95
Stressing Specific Database Platforms
108
Conclusion
112
Concentrate on What and not How
126
Running Benchmark Jobs
142
Dont Rush to Conclusions
156
Extrapolation Interpolation
170

Combined Results Summary
65

Common terms and phrases

About the author (2007)

Dr. Bert Scalzo is an architect for Quest Software, has written articles for Linux Journal, Oracle Informant, Oracle Magazine, and is the author of Oracle DBA Guide to Data Warehousing, TOAD Handbook, and Toad Pocket Reference for Oracle. Kevin Kline is the director of technology for SQL Server Solutions at Quest Software and frequently contributes to database technology magazines, Web sites, and discussion forums. He is the author of SQL in a Nutshell and the coauthor of Transact-SQL Programming. Claudia Fernandez is a product manager of SQL Tuning products at Quest Software and has been a presentor at technical conferences on Application Performance Tuning topics. Donald K. Burleson is an Oracle database expert with more than 20 years experience who specializes in creating database architectures for large online databases. A former adjunct professor, he has written 30 books, published more than 100 magazine articles, and serves as editor-in-chief of Rampant TechPress. Mike Ault is a senior technical management consultant and the author of more than 20 Oracle books, including Oracle7 Administration and Management and Exam Cram, and hundreds of articles for national publications.

Bibliographic information