Customer Reviews

Microsoft SQL Server(TM) 7.0 Performance Tuning Technical Reference (IT-Microsoft Technical)

5 star:		(3)
4 star:		(1)
3 star:		(2)
2 star:		(1)
1 star:		(0)

 

 

Definitely not another Books Online. I bought this book to better understand hardware requirements for VLDB systems (1+Terabytes)... the book explains in great depth all vital hardware components in a system (RAID levels, CPU, RAM)... not just what is best but why, and the dynamics of how each component functions. The Sizing and Capacity Planning section was also great, as it gave mathematical equations for calculating system statistics... equations I had not seen before. I did not find the performance monitoring section especially helpful - although the book did make good suggestions about charting db performance over time.

I have been very satisfied with "Inside SQL Server" for so long, and have been keeping it by my desk. However, this one is more focused on Performance Tuning. You can find things from planning your hardware until tuning your Datawarehouse in here. Lastly, if you want to know about the detail architecture of SQL Server, get "Inside SQL Server". If you want to focus on Performance Tuning, this is the best book so far. I will keep both of them by my desk.

I have been tuning SQL Server databases for some time, and have not seen such a good reference short of the Inside SQL Server series originated by Ron Soukup.

I strongly recomend this book for everyone creating or maintaining an enterprise database.

Microsoft SQL Server(TM) 7.0 Performance Tuning Technical Reference (It-Microsoft Technical Reference) by Jamie A. Reding is a more technical and in detail guide to things you can do to tweak your SQL Server database for various reasons and for various tasks. It is ok, but better out there. Standard sort of Microsoft book.

If you find yourself navigating the online bible (SQL Books Online) to figure something out then you are better off buying something else. I was dissapointed that no value was added beyond what you can get from the online books.

I wish all books were written this well.

Great job.

I found this book to be an OK reference. However, the author has mistakes in the treatment of RAID levels for DASD. Nice high level view of queuing theory and the basics of using histograms for analysis.