Database Benchmarking: Practical Methods for Oracle & SQL Server

Be the first to write a review

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

See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (7) from $1.99   
  • New (1) from $65.0   
  • Used (6) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$65.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

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.

 

 

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Are 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

Read More Show Less

Product Details

  • ISBN-13: 9780977671533
  • Publisher: Rampant Techpress
  • Publication date: 4/1/2007
  • Series: IT In-Focus series
  • Pages: 200
  • Product dimensions: 9.00 (w) x 7.00 (h) x 0.50 (d)

Meet the Author

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.

Read More Show Less

Table of Contents


Using the Online Code Depot     1
Supplemental Materials     2
Conventions Used in this Book     3
Acknowledgements     4
Preface     5
Introduction to Benchmarking     6
Database Predictive Analysis     6
Database Benchmark Validity     7
The Problems of Adaptive Threshold Forecasting     8
Predictive Modeling in the Real-world     9
Benefit of Predictive Analysis     11
The Transaction Processing Performance Council     12
Benchmarking Bi-modal Databases     13
Capacity Planning & Testing     13
Forecasting the Future     14
Database Benchmarking Myths     15
Learning from Database Benchmarks     15
Conclusion     16
Database Benchmarking     17
Standard Benchmarks     19
Benchmark Components     21
Specifications     21
Details     21
Design Goals     21
Data Points     22
Test Plan     22
Control Togic     23
Repeatability     23
Accurate Statistics     23
Using Benchmark Factory     23
TPC-C     26
TPC-H     31
TPC-E     33
AS3AP & Scalable Hardware     34
Benchmarking with a Custom Workload     35
Conclusion     36
Capacity Planning Analysis     37
Introduction     37
Trend Identification     38
Testing an Architecture     39
System Information     40
Database Objects     41
Details of Materialized View     41
Transaction Details     43
Insert Transaction     44
Select Transaction     44
Phase 1     45
Insert & Select Varying     45
5 Concurrent Selects     50
10 Concurrent Selects     53
12 Concurrent Selects     55
Phase 3: Materialized View with No Partitions     58
Combined Results     62
Combined Results Summary     65
Recommendations     66
Planning Future Hardware & Software Needs     66
Architecture     67
Executive Summary     67
Limitations and Caveats     68
Phase 1: Issues Query Testing     69
Randomization of the Issues Queries     69
Transaction Times for Issues Tests     70
Average Transaction Times     72
Database Activity     74
Operating System Activity     78
Phase 1 Conclusion     81
Maintaining Service Level Agreements (SLA's)     81
Determining SLA Test Queries     82
Ok, here is the SLA and Queries, What Now?     83
Issues with Generating Your Own Scripts     83
The Easy Way     85
Supporting Server & Storage Consolidations     85
Conclusion     89
Stressing the Database     90
Introduction     90
Database Implosion Therapy     91
Hardware Issues in Stress Testing     92
Configuring the Server Environment     94
Stress Testing Specific Workloads     95
Stressing Read-Only Databases (Read-only Implosion)     97
Stressing OLTP Databases (DML Implosion)     100
Stressing Mixed Databases (General Implosion)     103
Stressing Specialized Environments     103
Stressing Distributed Systems     104
Stressing Consolidated Systems     105
Stressing Virtualized Systems     107
Stressing Specific Database Platforms     108
Not all SQL Implementations up to Spec     109
Not all Quer Optimizers Created Equal     111
Conclusion     112
Preparing for Benchmarking     113
Isolate the Benchmark Environment     114
Prepare the Server Operating System     115
Windows     115
Linux     118
Prepare the Database Configuration     120
SQL Server     120
Oracle     123
Concentrate on What and not How     126
Installing Benchmark Factory     127
Conclusion     130
Running the Benchmarks     132
Selecting among Benchmarks     133
Creating Benchmark Jobs     137
Running Benchmark Jobs     142
Monitoring Benchmark Runs     145
Special Oracle RAC Considerations     151
Conclusion     154
Interpreting Benchmark Results     155
Don't Rush to Conclusions     156
An Example on Oracle     156
An Example on Microsoft SQL Server     159
Finding the 'Sweet Spot"     159
When Conclusions are not Self-Evident     164
Correlating Results     165
Real-time versus "Run" Reports     166
Extrapolation & Interpolation     170
Documenting the Final Analysis     173
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)