The SQL Server 6.5 Performance Optimization and Tuning Handbook

Features

• Cover Type: Paperback with 259 pages
• Published by: Butterworth-Heinemann July 1997
• Written in: English
• ISBN 10 Number: 1555581803
• ISBN 13 Number: 978-1555581800
• Book Dimensions: 9.2 x 7 x 0.6 inches
• Weighs: 15.2 ounces

Product Description
* Follow up to The SQL Server Handbook

* Detailed look at factors that influence database performance

* Covers internal storage structures, indexes, and integrating SQL with Windows NT

The SQL Server 6.5 Performance Optimization and Tuning Handbook takes a detailed look at the factors that influence database performance, beginning with good physical design. The internal storage structures are covered next, because an understanding of these is essential to performance tuning. The critical subject of indexes is then discussed, followed by the query optimizer, which is perhaps the most crucial SQL Server performance topic. Making mistakes in these areas can mean the difference between a query taking seconds or literally hours.

Publisher Description
SQL Server is highly integrated with Windows NT and so it is crucial that it and Windows NT are both optimized to work together. The book covers the extent of this integration, how to detect CPU, memory and disk bottlenecks and how to overcome them. In a multi-user system, the biggest performance headache is probably locking and this subject is discussed in detail with many example scenarios. Once an efficient physical design has been obtained it is necessary to monitor performance, and a chapter is devoted to the performance monitoring tools available with SQL Server. Finally, a performance, tuning and optimization checklist is provided as an aid for the database administrator.

Reader Reviews
After you have spent 8-80 hours trying random combo's on the Server Configuration panel trying to guess what you should do, buy this book and score a direct hit! Microsoft should bundle this book with SQL Server. If a little more detail were provided on the internal data structures of SQL Server one could write a bulk loader that bypassed SQL Server entirely (I know its been done by others) and load ten X as fast. (hint-hint) This is the closest thing to a K&R for MS SQL Server I've ever seen. I really like the brevity of this book. Every word counts! Very, very good job Ken!