You are previewing Configuring and Tuning Databases on the Solaris™ Platform.
O'Reilly logo
Configuring and Tuning Databases on the Solaris™ Platform

Book Description

  • Turbocharge your Oracle, DB2, Sybase, or Informix database environment!

  • Covers every aspect of database and Solaris Operating Environment tuning

  • Optimize data layout, CPU and memory configuration, and system sizing

  • Identify and resolve bottlenecks, step-by-step

  • Understand industry-leading benchmarks

Maximize the performance of any enterprise database running on the Solaris Operating Environment!

Using this book, database professionals can optimize the performance and cost-effectiveness of virtually any database application running on the Solaris platform. Database specialist Allan Packer presents start-to-finish guidance for optimizing all four leading Solaris platform databases: Oracle (including Oracle9i), DB2, Sybase, and Informix XPS. Drawing on years of expertise as an engineer at Sun, Packer brings together best-practice guidelines for every aspect of Sun database server tuning.

  • Optimizing data layout, CPU and memory configuration, and system sizing

  • Identifying and resolving bottlenecks: a systematic, drill-down monitoring approach

  • Understanding database optimizers, database buffer cache, and other key subsystems

  • Demystifying the industry's leading benchmarks-and recognizing their limitations

  • Understanding the impact of Java technology on database application design

  • Contains a quick primer on database architecture and concepts

Table of Contents

  1. Copyright
  2. List of Figures
  3. List of Tables
  4. Foreword
  5. Preface
  6. Acknowledgments
  7. Databases on Sun Servers
    1. Sun's Relationship with Database Vendors
      1. The Nature of the Relationship
      2. The Major Database Suppliers
    2. The Role of Database Engineering at Sun
      1. Sun’s Database Engineering Group
      2. The Ambassador Program
    3. Solaris Optimizations for Databases
      1. Scheduling Optimizations
      2. I/O Optimizations
      3. Other Optimizations
      4. Dynamic Reconfiguration
    4. Hardware Architecture and Databases
      1. Hardware Architectures
      2. Databases on SMP and NUMA Systems
      3. Shared-Disk Databases on SMPs
      4. Shared-Nothing Databases on SMPs
  8. Database Architecture
    1. Introduction to Database Architecture
      1. Architecture of Relational Databases
      2. Process Models
      3. Parallel Processing
      4. Distributed Databases
      5. Replicated Databases
      6. Transaction Monitors
    2. Database Workloads
      1. Online Transaction Processing (OLTP)
      2. Decision Support Systems (DSS)
      3. Batch Workloads
      4. Online Analytical Processing (OLAP)
    3. The Role of the Buffer Cache
      1. Overview of the Buffer Cache
      2. Monitoring the Buffer Cache
      3. Sizing the Buffer Cache
    4. The Role of the Database Optimizer
      1. Query Optimizers
      2. Optimization Methods
      3. Reducing the Workload
    5. Oracle Architecture
      1. Process Model
      2. Memory Management
      3. Physical Data Storage
      4. Logical Data Storage
      5. System Tablespace
      6. Parallel Processing
    6. Sybase Architecture
      1. Process Model
      2. Memory Management
      3. Physical Data Storage
      4. Logical Data Storage
      5. System Databases
      6. Parallel Processing
      7. Adaptive Server IQ with Multiplex
    7. Informix XPS Architecture
      1. Process Model
      2. Memory Management
      3. Physical Data Storage
      4. Logical Data Storage
      5. System Database
      6. Parallel Processing
    8. Db2 for Solaris Architecture
      1. Process Model
      2. Memory Management
      3. Physical Data Storage
      4. Logical Data Storage
      5. System Tablespaces
      6. Parallel Processing
      7. Other DB2-Related Products
  9. Sizing and Configuring Sun DBMS Servers
    1. Sizing Systems for Databases
      1. Basis of a Sizing Estimate
      2. The Right Questions
      3. Using Published TPC Results for Sizing
      4. Using Remote Terminal Emulators
      5. Summary of Rules of Thumb
      6. A General-Purpose OLTP Sizing Tool
    2. Configuring Systems
      1. Solaris Configuration
      2. Memory Interleaving
    3. Configuring CPU
      1. Managing Workloads
      2. CPU Performance
    4. Configuring the Network
      1. Performance Considerations
      2. Availability Considerations
    5. Data Layout
      1. Storage Subsystems
      2. Volume Managers
      3. Data Layout Technologies
      4. Data Layout Strategies
      5. File System Alternatives
      6. High Availability
      7. Other Data Layout Issues
      8. Storage Cocktails
      9. Data Layout Recommendations
      10. A Worked Example
  10. Performance Monitoring and Tuning
    1. Troubleshooting Methods
      1. Problem-Solving Strategy Development
    2. Major Contributors to Poor Performance
      1. Performance Problem Identification
      2. The Next Step
    3. System Performance Monitoring Tools
      1. Basic Solaris Tools
      2. Monitoring Intervals
      3. Other Monitoring Tools
    4. Drill-Down Monitoring
      1. STEP 1. Monitoring Memory
      2. STEP 2. Monitoring Disks
      3. STEP 3. Monitoring Networks
      4. STEP 4. Monitoring CPUs
      5. STEP 5. Monitoring and Tuning a Database
      6. EXTRA STEP: Checking for ISM
    5. Monitoring and Tuning Oracle
      1. Managing Oracle Behavior
      2. Monitoring Oracle with utlbstat/utlestat
      3. Monitoring the Shared Pool
      4. Tuning Oracle
      5. Applying Other Tuning Tips
      6. Reconfiguring Oracle9i Dynamically
      7. Recovering Oracle
    6. Monitoring and Tuning Sybase
      1. Sybase ASE Monitoring
      2. Tuning Sybase ASE
    7. Monitoring and Tuning Informix XPS
      1. Informix XPS Monitoring
      2. Tuning Informix XPS
    8. Monitoring and Tuning DB2 for Solaris
      1. Monitoring DB2
      2. Tuning DB2 for Solaris for DSS Workloads
      3. Tuning DB2 for Solaris for OLTP Workloads
      4. General Tuning Tips
    9. Metrics: How to Measure and What to Report
      1. Common Performance Metrics
      2. Choosing Statistics
      3. Scalability Demystified
      4. Lies, Damn Lies, and Statistics
      5. When the Same Thing Isn’t
      6. Conclusion and Recommendations
  11. Other Topics
    1. Benchmarking
      1. Industry-Standard Database Benchmarks
      2. Usefulness of Database Benchmarks
      3. Introduction to TPC-C
      4. Introduction to TPC-D, TPC-R, and TPC-H
      5. Introduction to TPC-W
      6. TPC Results in a Competitive Environment
      7. Running Your Own Benchmark
      8. Conclusion
    2. Java Interfaces, Middleware, and Databases
      1. Java in the Database
      2. Java Interfaces to Databases
      3. J2EE Middleware
  12. References
    1. Web-Based Product Manuals
    2. Technical Books