Book VII
Database Tuning Overview
Book VII
Database Tuning Overview
Contents at a Glance
Chapter 1: Tuning the Database
Analyzing the Workload
Considering the Physical Design
Choosing the Right Indexes
Tuning Indexes
Tuning Queries
Tuning Transactions
Separating User Interactions from Transactions
Minimizing Traffic between Application and Server
Precompiling Frequently Used Queries
Chapter 2: Tuning the Environment
Surviving Failures with Minimum Data Loss
Tuning the Recovery System
Tuning the Operating System
Maximizing the Hardware You Have
Adding Hardware
Working in Multiprocessor Environments
Chapter 3: Finding and Eliminating Bottlenecks
Pinpointing the Problem
Determining the Possible Causes of Trouble
Implementing General Pointers: A First Step Toward Improving Performance
Tracking Down Bottlenecks
Analyzing Query Efficiency
Managing Resources Wisely
Get SQL All-in-One For Dummies®, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.
Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.
Start your free trial Become a member now