Tuning the Buffer Cache

Objectives

Overview

Managing the Data Buffer Cache

Managing the Data Buffer Cache

Tuning Goals and Techniques

Diagnostic Tools

Measuring the Cache Hit Ratio

Guidelines for Using the Cache Hit Ratio

Using Multiple Buffer Pools

Defining Multiple Buffer Pools

Defining Multiple Buffer Pools

Enabling Multiple Buffer Pools

Keep Buffer Pool Guidelines

Recycle Buffer Pool Guidelines

Recycle Buffer Pool Guidelines

Calculating the Hit Ratio for Multiple Pools

Identifying Candidate Pool Segments

Dictionary Views with Buffer Pools

Other Performance Indicators

Caching Tables

LRU Latches

LRU Latch Tuning Goals

Diagnosing LRU Latch Contention

Resolving LRU Latch Contention

Free Lists

Diagnosing Free List Contention

Resolving Free List Contention

Summary