Database Tuning: Principles, Experiments, and Troubleshooting Techniques

Description

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one. Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM) Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Other editions

• 

  Database Tuning: Principles, Experiments, and Troubleshooting Techniques

  • 2003
  • 415 pages
  • Paperback
  • Morgan Kaufmann
• 

  Database Tuning: A Principled Approach

  • 1992
  • 239 pages
  • Paperback
  • Prentice Hall

Similar books

• 

  SQL Tuning: Generating Optimal Execution Plans

  By Dan Tow

  Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems.

• 

  Oracle Data Warehouse Tuning for 10g

  By Gavin JT Powell

  4.3.5 Materialized View ORDER BY Clauses A materialized view creation query can contain an ORDER BY clause. The ORDER BY clause will help to physically sequence data. However, materialized views are maintained by underlying tables, ...

• 

  Database Performance Tuning and Optimization: Using Oracle

  By Sitansu S. Mittra

  Presents an ideal mix of theory and practice, which allows the reader to understand the principle behind the application.; Coverage of performance tuning of datawarehouses offers readers the principles and...

• 

  Automated Physical Database Design and Tuning

  By Nicolas Bruno

  What-if optimization calls can be avoided in some scenarios by inferring costs from previous optimizations of atomic configurations. • INUM and CPQO are techniques that can reoptimize queries ... Automatic physical database tuning: A ...

• 

  Oracle Database 12c Performance Tuning Recipes: A Problem-Solution Approach

  By Darl Kuhn, Sam Alapati, Bill Padfield

  Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book.

• 

  SQL Performance Tuning

  By Peter Gulutzan, Trudy Pelzer

  This book will help DBAUs and programmers improve the performance of their databases.

• 

  MySQL Database Design and Tuning

  By Robert D Schneider

  MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL.

• 

  Configuring and Tuning Databases on the Solaris Platform

  By Allan N. Packer

  Covers key performance issues related to using leading databases on Sun servers for system administrators and database programmers. This book brings together best-practice guidelines for every aspect of database tuning on Sun servers.

• 

  Oracle Performance Survival Guide: A Systematic Approach to Database Optimization

  By Guy Harrison

  If we issued a query for Ian Smith, we would first retrieve all employees with the surname of Smith, and then retrieve all employees with the first name of Ian. The two sets would be merged, and only employees in both sets (that is, ...

• 

  Oracle Database 11gR2 Performance Tuning Cookbook: Over 80 Recipes to Help Beginners Achieve Better Performance from Oracle Database Applications

  By Ciro Fiorillo

  In this book you will find both examples and theoretical concepts covered.