SQL Server Query Performance Tuning Distilled

by Sajal Dam

Book Overview

The second edition includes updated material plus one new chapter, and explains how to design and tune SQL Server applications to cope with ever-increasing workloads. With proven strategy, this book shows how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements. Also covered are crucial issues like index analysis and tuning, preventing deadlocks,...

• Format: Paperback
• Language: English
• ISBN: 1590594215
• ISBN13: 9781590594216
• Release Date: October 2004
• Publisher: Apress
• Length: 624 Pages
• Weight: 2.40 lbs.
• Dimensions: 1.3" x 7.4" x 9.3"

Customer Reviews

Good book. Buying one for each member of my team.

Microsoft says "the greatest benefit in SQL Server performance can be gained from the general areas of logical database design, index design, query design..." This book will go a long way in helping you improve those areas. I got the APRESS second edition and have not had the problems others seem to have had getting code or having chapters missing. Most of the people in my team are developers rather than hard core DBAs and I am going to get each one of them a copy of this book. I find it well written and easy to understand. I especially like the little nuggets scattered throughout such as why you should execute a stored procedures in the correct case on a case-insensitive SQL Server. Screen prints, flow charts, and illustrations throughout enhance the clarity of the author's text. I am very satisfied with this book.

Excellent book focused on SQL Server

This book is primarily focused on getting the most performance out of SQL servers. Overall the book is well written and very well illustrated. There are some weakpoints where code samples are overused, but those are few and far between. The standout chapters, like the one fragmentation analysis are worth the price of admission for people looking to use SQL server in large performance critical deployments. This book should be compared with O'Reilly's equally excellent "SQL Tuning" book (0596005733). That book is more theoretical in nature, often using equations and graph theory to demonstrate how get the fastest queries. This book is much more practical in nature, often showing screen shots and pointing out directly what is most critical. It's in the understanding of the reader where this book excels. All too often authors understand the topic but do not understand how to present it. Sajal obviously understands the fine points of the technology, but also understands how to pass on that experience effectively. I highly recommend this book for anyone working in an environment where high performance database work is required, and where the database is SQL Server.

A Very Good SQL Server Performance Tuning Book

I am a SQL Server 2000 performance consultant - TuneSQLServer.com. This author presents the right stuff - lots of Query Analyzer and Profiler information. What is unique about this book is the large number of Query Analyzer graphical query plans. That is the right way to learn about performance and the best way to tune a system. I could worry about this book putting me out of business, but I know that it takes a long time to really understand the issues which are presented. Sure theory is nice. The guy who gave the nasty review must be a serious competitor - g. Chapter 8 of the book has a large discussion about data fragmention. Sure, the optimizer can use DB integrity constraints as hints to formulate better plans, but constraints are not crucial. They are only helpful to the optimizer in a few cases when it is working on a very complex query. And about statistics histograms. Yes you should know that they exist on the first column of an index and that is about it. What is really important is being able to read the information in a Query Analyzer graphical plan to see if estimated values based on the statistics histograms differ greatly from the actual values when the query is run - turn on the Query / Show Execution Plan option and run your query. If the results are way off, you may end up scratching your head for a while. Estimates are only estimates and in some cases they are way off and that is the problem you must deal with. There are solutions even in those case but they are not always pretty. For God sakes, leave auto statistics update set to On. And only use a query hint as a very very last resort - that means almost never. The common problem I see is that people spend too much time learning SQL Server 2000 theory. That time is better spent becoming fluent in reading graphical plans in Query Analyzer and doing experiments like those shown in the book. It is best to have developers get the correct results with their SQL and then tune the parts that Profiler shows are a problem. Too much time is spent trying to optimize queries during the design phase. The so called "optimized query formulations" often run slow because the developers don't have advanced SQL Server 2000 performance skills. What is the point in trying to optimize when you really don't know how to do it - a waste of time. Sure, try to use techniques that are known to work well, but don't overdo it. Most of the time what I see are query formulations and indexes that were supposed to be optimized by theory and in practice run badly. I often speed up systems 2 to 10 times by fixing weird problems that theory doesn't cover. The book does a good job setting the correct focus on using Query Analyzer and Profiler. Don't theorize, see what is actually happening and use experience and the bag of tricks to deal with the performance issues. There are no silver bullets to SQL Server 2000 performance tuning. Some problems are easy to solve but many complex queries take a lot of experime

My favorite SQL Server book

This book is always on my desk, as it turns out to very useful al the time. The book contains so many examples and it is going very deep into the details of tuning. I learned a lot of how to optimize my queries and I look every time at the pages read in a query. My version contains parts about database constraints and index defragmentation. I like the style it is written in, very compact like most math books. But is seems to be you need to be an experienced user to get it all what's in the book..

Addressing the concerns of the readers

I'm the author of the book "SQL Server Query Performance Tuning Distilled." To address the concerns of the readers of my book, I have started working with Apress. Apress understands the popularity of the book and has rendered the code samples for download at www.curlingstone.com. Apress is putting sincere effort in promoting the book. Meanwhile, if you find the content of the book highly useful for your database team, then I can consider sharing the knowledge with your team; if time permits, I may be able to deliver a good part of the content in a two-day presentation. If you feel that such an effort on my part will be useful for you and your team, then please feel free to write to my emailid sajaldam1@hotmail.com.