Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) Paperback – March 16, 2009
There is a newer edition of this item:
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Frequently Bought Together
Customers Who Bought This Item Also Bought
About the Author
Sajal Dam holds a master's of technology degree in computer science from the Indian Institute of Science, Bangalore, and has been working with Microsoft technologies for over 12 years. He has developed an extensive background in designing database applications and managing software development. Sajal also possesses significant experience in troubleshooting and optimizing the performance of Microsoft-based applications, from front-end web pages to back-end databases.
While working at Microsoft, Sajal helped many Fortune 500 companies design scalable database solutions and maximize the performance of their database environments. As an IT strategist at Dell, Sajal manages Dell's vast database infrastructure by optimizing not only the databases, but also the database management processes, tools, and use of best practices. He also works closely with the application development teams and vendors, including Microsoft, in analyzing and resolving performance bottlenecks.
pstrongGrant Fritchey/strong works as a development database administrator for FM Global, an industry-leading engineering and insurance company. In his previous time as a database administrator and developer, he has worked at three failed dot-coms, a major consulting company, and a global bank. He has developed large-scale applications in languages such as VB, C#, and Java and has lived with SQL Server from the hoary days of 6.0, right through to 2008. His nickname at work is "The Scary DBA." He even has an official name plate, and he displays it proudly. /p pGrant volunteers for the Professional Association of SQL Server Users (PASS) and has written and published articles on various topics relating to SQL Server at Simple-Talk, SQL Server Central, SQL Server Performance, the PASS web site, SQL Standard, and the SQL Server Worldwide Users Group. He is the author of the book emDissecting SQL Server Execution Plans/em. He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG)./p pOutside work, Grant kayaks, learns and teaches self-defense, brews his own beer, chops wood to heat his house, raises his kids, and helps lead a pack of Cub Scouts./p
More About the Author
Top Customer Reviews
Several times in the last two weeks, I reached for this book first.
Query performance tuning is the art of reading a query's execution plan, figuring out why it's not fast, and then determining the most cost-effective way to make it faster. Anybody can throw more indexes in and just hope it speeds up, but as the book illustrates, sometimes that can hurt more than help.
To do a good job, the tuner needs to know about indexing, statistics, execution plans, compilations, blocking, deadlocks, and query design issues that can force a query to perform poorly. Some of this stuff is covered in abstract terms in college classes, but for the most part, all of us - developers, DBAs, sysadmins - are pretty much unprepared to guess what's going on inside the SQL Server engine.
When you first design and deploy an application, that's a great thing: you don't need to know what's going on inside the black box. SQL Server handles a lot of load with the default settings, with pretty much any application design, before things start to creak and groan. I've seen people build amazingly big SQL Server applications without any knowledge of how indexes or execution plans work. When you start to run into performance problems, you need expert help fast - and that's what this book provides.
Regardless of your seniority level, you're going to find this book's price an extremely worthwhile investment. The book's authors, Grant Fritchey and Sajal Dam, strike a great balance between bringing you up to speed versus diving into advanced concepts. Chapter 4 on Index Analysis is a great example.Read more ›
I will suggest this book for other DBAs and SQL Programmers who want to know the theories behind Index and Statistics, BLocking and Deadlocking, Fragmentation.
On the initial chapters, you can find a good introduction on Performance tuning, Performance analysis and on the Database Engine Tuning Advisor. There are various analysis and optimization techniques explained in later chapters. There is comprehensive information about most common performance issues that occurs due to Query designs and deadlocks.
We can find more information on tuning indexes like when and where to apply what type of index. Later, the workload optimization techniques explains ways to identify and research expensive queries and jobs and "What not" to do to avoid performance issues. This book helps not only to write individual queries without any performance flaws, it also helps to find where the flaws are in existing queries. I would like to mention that there are good of examples of queries (which everyone look for) which make the reader to understand where performance issues or bottlenecks occur and what to do with it.
One good sense I had when I started reading the book is it isn't that hard to read through the book even you are new to performance tuning in SQL server. I would strongly recommend this book for all database performance professionals (Even the beginners in Performance Tuning).
So perhaps the most interesting thing in the book regarding the topics covered is that includes all the aspects to take into account when writing queries like the tools to verify execution plans, analysis of cursors, deadlocks and all the wonderful stuff we run into when dealing with queries.
However, nothing is perfect. One of the problems I found when reading it is that it doesn't cover subjects like T-SQL Refactoring or techniques to handle integration with other systems like Oracle. But don't get me wrong, this are rare environments and only happen with big companies with lots of systems. Anyway maybe for a future edition. The other thing is that is not the definitely guide to tuning queries, although is very close.
Most Recent Customer Reviews
Excellent book to get a complete understanding about sql server. Must buy.Published 6 months ago by safia syed
This book helped me a lot! Reading this book I solved some serious problems.Published 15 months ago by Arnis Skrastins
Covers a lot of topics and gives you good background. I would recommend the book, although it is a bit dry at times.Published on November 28, 2013 by josh168
No letters look good, you can not see the images, it is a scam the've bought, again should digitize to read it properlyPublished on September 27, 2013 by Edwin Rimapa
This book is packed with tons of great material. I also find it to be an somewhat easy read. Especially given the material that it covers. Read morePublished on August 13, 2013 by Frank Hunt
Lots of technical detail on query tuning from all the aspects. Great resource to have useful in all versions of SQL server not just 2008. Keep it on your bookshelf!Published on July 29, 2013 by B. P. ODwyer
I have been very surprised about how many new ways of optimisation exist. Definitely a "must-read" for DBA or DBD.Published on July 2, 2013 by Andrey
This book not only taught me how to find and fix my performance issues. It gave examples on how to prove it helped. It is also written in a very informative and organized method. Read morePublished on April 4, 2013 by Glenn E. Graham
Great book well written on the subject and details needed for any level user/reader/DBA. I expect to reference and quote it often.Published on December 27, 2012 by Hank Freeman