Microsoft SQL server 7.0 performance tuning : technical reference / Steve Adrien DeLuca . . . [et al.].

PART 1 BASIC CONCEPTS
1 Performance Tuning, Capacity Planning and Sizing Overview
Performance Tuning and Optimization
Sizing and Capacity Planning
Server Tuning Methodology

2 SQL Server 7.0 Architecture
Memory Management
Data Storage
Lock Management

3 UNDERSTANDING THE 1/0 SUBSYSTEM AND RAID
Performance Characteristic of Disk Drives
Introduction to RAID
Common RAID Levels
Performance Comparison of RAID Levels
1/0 Latencies and SQL Server, etc

4 TUNING SQL SERVER
How to Measure performance
Tuning the Server Hardware
Optimizing Database Layout
SQL Server Configuration Parameters

5 NEW FEATURES AND PERFORMANCE ENHANCEMENTS
Dynamic Configuration
Improved performance and other New Features

6 MONITORING PERFORMANCE WITH ENTERPRISE MANAGER AND THE PERFORMANCE MONITOR
Enterprise Manger
Performance Monitor

7 USING SQL SERVER PROFILER
SQL Server Profiler Overview
Using the Profiler
Sample Scenarios
Debugging SQL Statements

PART II SIZING AND CAPACITY PLANNING
8 Modelling for sizing and capacity planning
9 Sizing the Database and Application Servers
preconfiguration Capacity Planning
Disk Requirements of the Database Server
Sizing the Application Server

10 METHODS FOR SIZING A SYSTEM
Sizing the processor
Calculating System Statistics
sizing Memory
Sizing the Disk 1/0 Subsystem

11 CAPACITY PLANNING
Performance Tuning vs. Capacity Planning
Data Collection
Data Analysis

PART II CONFIGURING AND TUNING THE SYSTEM
12 ONLINE TRANSACTION PROCESSING SYSTEMS
What is an OLTP System?
Guidelines for Designing OLTP Systems
OLTP Tuning

13 DATA WAREHOUSES AND DATA MARTS
Definitions and Characteristics
Designing a Data Warehouse
Tuning a Data Warehouse

14 TUNING REPLICATED SYSTEMS
Replication Overview
The Distributor

Tuning for Snapshot Replication
Tuning for Transnational Replications, etc.

15 HIGN-PERFORMANCE BACKUP AND RECOVERY
Backup and Recovery Concepts
Factors Affecting Performance of Backup and Recovery
Configuring the System for Maximum Backup and Recovery Performance
Backup Scenarios
Backup Tips and Recommendations, etc.

PART IV TUNING SQL STATEMENTS
16 USING SQL SERVER QUERY ANALYZER
Features of SQL Server Query Analyzer
Running SQL Server Query Analyzer
Execution plans
Interpreting Graphical Execution plans
Example of Using Query Analyzer

17 TUNING SQL STATEMENTS AND STORED PROCEDURES
Application Design
Using Stored Procedures
Coding SQL Statements as Transactions
Efficient Retrieval of DATA
Tuning SQL Queries

18 USING AND TUNING INDEXES
Index Fundamentals
Tuning Indexes
Summary

19 USING HINTS IN SQL SERVER
Isolation Levels
SQL Hints
Summary

PART APPENDIXES AND GLOSSARY
A SQL Server Configuration Parameters
B SQL Server Monitoring

Includes Index : p.385-421