Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
SQL Server 2008 Query Performance Tuning Distilled
By: Grant Fritchey; Sajal Dam
Publisher: Apress
Pub. Date: March 2009
Print ISBN: 978-1-43021-902-6
Web ISBN: 1-430219-02-5
Pages in Print Edition: 600
Subscriber Rating:
[4 Ratings] Subscriber Reviews
Overview
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: 
Based on 4 Ratings
"SQL Server 2008 Query Performance Tuning Distilled" - by Anonymous on 25-APR-2011
Reviewer Rating:
Very nice book
Report as Inappropriate
"Good but dated" - by Anonymous on 11-JAN-2010
Reviewer 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
Browse Similar Topics
Top Level Categories:
Information Technology & Software Development
Product
Vendor
Sub-Categories:
Information Technology & Software Development > Databases
Databases > SQL Server 2008
Product > Microsoft SQL Server 2008
Vendor > Microsoft
Table of Contents
Extras
The publisher has provided additional content related to this title.
Description | Content |
|---|---|
These links have been provided by the publisher. |
|