Microsoft SQL Server 2000 Performance Tuning Technical Reference

Microsoft SQL Server 2000 Performance Tuning Technical Reference
by Edward Whalen and others
Copyright 2001
Microsoft Press

Find out more about this book, or purchase it, from Amazon.com

When I picked up this book and began to flip through the pages, I experienced a sense of deja vu, it was like I had read this book before. Upon closer examination, I had, it was the previous edition of this book, Microsoft SQL Server 7.0 Performance Tuning Technical Reference. No, these two books aren't identical, the newer one has been updated for SQL Server 2000, and other improvements have been made. So if you have the older edition already, you probably won't benefit too much from purchasing the new edition, unless of course you are one of those kind of people who must have ever little bit of information they can get their hands on.

But if you don't own a copy of the older edition of this book already, I highly suggest you put in on your list of "must-have" SQL Server books. I consider this book basic reading for all SQL Server DBAs who are interested in boosting the performance of SQL Server. And of course, this means all DBAs, as what DBA isn't concerned with performance?

Here are the SQL Server performance topics you will learn about in this book:

• Performance Tuning, Capacity Planning, and Sizing Overview

• SQL Server 2000 Architecture Fundamentals

• Understanding the I/O Subsystem and RAID

• System Tuning

• New Features and Performance Enhancements

• Monitoring Performance with System Monitor

• Using SQL Profiler

• Modeling for Sizing and Capacity Planning

• Sizing the Database Application Servers

• Methods for Sizing a System

• Capacity Planning

• Online Transaction Processing Systems

• Data Warehouses

• Tuning Replicated Systems

• High-Performance Backup and Recovery

• Using SQL Query Analyzer

• Tuning SQL Statements and Stored Procedures

• Using and Tuning Indexes

• Using Hints in SQL Server

• SQL Server Configuration Options

• SQL Server Monitoring

As you can tell from the above topics, this book is more designed for the SQL Server DBA than the SQL Server developer, although I am sure most developers will earn something from this book.

I highly recommend this book to all DBAs who want to learn how to get the most out of SQL Server 2000.