The SQL Server 6.5 Performance Optimization and Tuning Handbook

(9)
The SQL Server 6.5 Performance Optimization and Tuning Handbook image
Released: Aug 04, 1997
Publisher: Digital Press
Format: Paperback, 248 pages

Description:

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

Best prices to buy, sell, or rent ISBN 9781555581800




Frequently Asked Questions about The SQL Server 6.5 Performance Optimization and Tuning Handbook

You can buy the The SQL Server 6.5 Performance Optimization and Tuning Handbook book at one of 20+ online bookstores with BookScouter, the website that helps find the best deal across the web. Currently, the best offer comes from and is $ for the .

The price for the book starts from $32.80 on Amazon and is available from 5 sellers at the moment.

If you’re interested in selling back the The SQL Server 6.5 Performance Optimization and Tuning Handbook book, you can always look up BookScouter for the best deal. BookScouter checks 30+ buyback vendors with a single search and gives you actual information on buyback pricing instantly.

As for the The SQL Server 6.5 Performance Optimization and Tuning Handbook book, the best buyback offer comes from and is $ for the book in good condition.

Not enough insights yet.

Not enough insights yet.