The SQL Server 6.5 Performance Optimization and Tuning Handbook

England Microsoft Certified Systems Engineer And A Microsoft Certified Trainer, Ken

ISBN 10: 1555581803 / ISBN 13: 9781555581800

Published by Digital Press, 1997

About this Item

Satisfaction Guaranteed or your money back.

Seller Inventory # 1555581803

Bibliographic Details

• Title: The SQL Server 6.5 Performance Optimization and Tuning Handbook
• Publisher: Digital Press
• Publication Date: 1997
• Language: English
• ISBN 10: 1555581803
• ISBN 13: 9781555581800
• Binding: Soft cover
• Condition: New

About this title

Synopsis

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.


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.

· 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

About the Author

Ken England is President and Founder of Database Technologies, a database consulting, product evaluation and training firm. A Microsoft Certified Systems Engineer and a Microsoft Certified Trainer, Ken England is widely regarded as an authority on SQL Server and other leading database products. He is also the author of the SQL Server 6.5 Performance Optimization and Tuning Handbook.