Microsoft rosoft SQL Server 2000 Performance Tuning Technical Reference (Technical Reference)

This guide gives you the practical information you need to configure and tune aSQL Svr 2000 database for better fastermore scalable solutions. Considering the difficulty of the topic, this book is a fairly easy read. The single best thing about the book is that the advice is actionable. You can read this book and immediately begin tuning.

Coverage is excellent - performance tuning, capacity planning, setting up disk drives, managing cpu, I/O, network, and memory, index tuning, backups, replication, OLTP versus OLAP, etc.

For each subject area, the authors explain the applicable concepts and SQL Server tools, and then systematically explain their application using practical examples.