Write for Us
Microsoft SQL Server 2000 Performance Tuning Technical Referenceby Edward Whalen and othersCopyright 2001Microsoft Press
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.
