Microsoft SQL Server 2000 Optimization Guide

Rating:
Summary: It certainly helped me thru my SQL 2000 tuning assignment!
Review: Simply put, It is the best!!! I (SQL Server DBA) just took a SQL Server 2000 performance tuning assignment and after looking at several SQL Server 2000 books, this one is the best for performance tuning and optimization! It is easy to read, and it got just the level of details I need. It also guide the readers step by step when dealing with more advanced topics. I certainly learned about the critical performance counters to monitor on Windows and SQL Server, so now I can focus just on the counters I need. I surely learned a lot more details about the performance monitoring, SQL Server profiling, best hardware setup for high availability/scalability and optimal configurations!

The author did put in her own experience in the book, which helps when dealing with real world situation. I highly recommend this book for SQL Server DBA's out there!