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
"synopsis" may belong to another edition of this title.
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.
"About this title" may belong to another edition of this title.
Other Popular Editions of the Same Title
Search results for The SQL Server 6.5 Performance Optimization and Tuning...
Stock Image
The SQL Server 6.5 Performance Optimization and Tuning Handbook
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G1555581803I3N00
Stock Image
The SQL Server 6.5 Performance Optimization and Tuning Handbook
Seller: SHIMEDIA, Brooklyn, NY, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Satisfaction Guaranteed or your money back. Seller Inventory # 1555581803