Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble-shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day-to-day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area.

  • Emphasizes the practical. Does not bury readers in theory.

  • Gives readers practical techniques to immediately apply in their daily work.

  • Dedicates a chapter to each of the most common, performance-related problem areas.

Subscriber Reviews

Average Rating: 4.5 out of 5 rating Based on 4 Ratings

"SQL Server 2008 Query Performance Tuning Distilled" - by Anonymous on 25-APR-2011
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Very nice book
Report as Inappropriate

"Good but dated" - by Anonymous on 11-JAN-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This is a good SQL performance book but in my mind it misses on a lot of the enhancements added in SQL 2005 & 2008 that can help with performance analysis of production systems.

Dynamic Management Views (DMV) are covered but only as a replacement for Performance Monitor not as a replacement for SQL Profiler.  

The author still recommends running profiler on a production system which is always intrusive and impacts performance. DMVs already collect information on the slowest running queries and is invaluable in gathering information.

Report as Inappropriate

Table of Contents



The publisher has provided additional content related to this title.


These links have been provided by the publisher.

  • errata
  • examples