Title: Very good introduction, light on actual tuning
Product review: This book contains very clear introductions on how SQL server 2000 works, what are the important design considerations for creating a database, and has tutorials on the various tuning tools. As an introduction on SQL Server workings, it is very good. However, it is also very light on how to actually monitor and tune a real system. The tuning checklist is generic and many of the items are only applicable to designers, not someone who administers databases that may have been in existance for years. If you read the entire book, you can pick out handy items, but it does not give tuning examples, does not tell when to get concerned over particular parameters, nor go into which parameters (from the many supplied by the performance monitor) are really the important ones. As such, I did not find it much help in my daily activities as a DBA. I found "SQL Server 2000 for Experienced DBAs" by Brian Knight to be much more helpful.
Would you say this review depicts the product in a flattering or unflattering light?
