SQL Server Query Performance Tuning 4th Edition, Kindle Edition
Use the Amazon App to scan ISBNs and compare prices.
To get the free app, enter your mobile phone number.
Customers who bought this item also bought
Would you like to tell us about a lower price?
Top Customer Reviews
I am a blogger, writing reviews about IT books, IT articles and anything I find interesting. I have received the book "SQL Server Query Performance Tuning" from the publisher Apress for a review, upon a request from my site.
After October 2016 I have become a MCP in SQL Server (exam 70-461). In order to obtain the certification, I have decided to start reading mainly SQL Server books. </disclaimer>
The book is about Query Performance Tuning. After taking a look at the contents and the SQL Server Performance Killers, listed in the first chapter, one realizes that the book is written from someone with experience - the listed problems were ones I have also met in my life as a developer. In the next chapters, the book analyzes them one by one, showing how to avoid common pitfalls. In order to go more into details, I have to say that I liked the way the chapters were written - e.g. in the chapter, explaining the cursors, the author made a point that cursors should be avoided, but still explained how to work with them. In general, I am very satisfied with the book.
The book is good and detailed.
A small tiny minus - there were 2-3 figures in the book, where the text was unreadable.
In general I am happy with what I learned. :)
Thus, I am giving it 5 stars.
I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.
A popular performance tuning book gets updated for SQL Server 2014, how does it fare?
This well-liked SQL Server book examines performance from various angles, but concentrates on improvements related to the SQL code itself. The book has been updated for SQL Server 2014, additionally various chapters have been restructured. The book is aimed at anyone responsible for SQL Server performance, especially DBAs and developers.
Below is a chapter-by-chapter exploration of the topics covered.
Chapter 1 SQL Query Performance Tuning
This chapter opens with a discussion of the performance tuning process steps i.e. identify bottlenecks, prioritize issues, troubleshoot issues, apply resolutions, quantify change, and repeat. The price of any performance improvement is examined in terms of targets and having a good-enough solution. The importance of having a baseline is introduced early, allowing you to determine if current processing is ‘normal’.
Performance problems can be due to a variety of causes, including problems with hardware, operating system, network, database design and SQL code. Most problems are due to poor SQL code. The author discusses the major performance killers in outline here, and expands on them in the remainder of the book. Problems examined include:
• Insufficient indexing
• Inaccurate statistics
• Improper query design
• Poorly generated execution plans
• Excessive blocking and deadlocks
• Non-set-based operations, usually T-SQL cursors
• Inappropriate database design
• Excessive fragmentation
In many ways this chapter is a summary of the rest of the book. It provides a good overview of the performance tuning process, including a helpful flowchart. There’s a useful overview of the major causes of bad performance, each of which is expanded upon in subsequent chapters. There are good links to related chapters in the book.
This book covers a wide range of performance topics and techniques, with the central aim of improving the performance of your SQL workload. It is generally easy to read, with practical step-by-step walkthroughs, helpful links between chapters, and good use of screenshots. Typically, code is provided to back up the assertions made. The book should take your level of expertise from level 3 to level 8 (based on a 1 to 10 scale).
While this book covers the majority of code-based performance topics, there were times when I wanted more detail. There was no mention of the more advanced performance tools like SQLDIAG or SQL Nexus. Sometimes the structure of the book felt awkward e.g. perfMon is explained in the memory chapter but its example usage is given in a later chapter. Having a separate detailed tools chapter, that is repeatedly referenced, may have been better.
This book is very similar to the 2012 edition of the book; while the screenshots have been updated for 2014, the text is perhaps 80% the same or similar. Although written for SQL Server 2014, much is applicable to 2012 and 2008. If you want a good, wide ranging, SQL code optimization book, I can certainly recommend this book.