SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues

This book could be called 101 Best Wait Stats Solutions, and the title would probably only be inaccurate because there are more than 101 solutions in this book. There are almost 500 different wait types in SQL Server 2008, and that number is only going to increase over the next versions, so learning how to deal with wait stats now is very important. I think the best part about this book is that the author uses real world examples from his own experience in dealing with SQL Server, and also encourages feedback from his readers about what to add and improve. It’s almost like taking a SQL Server wait stats course, but you just have to pay for the book. There are ten chapters in this book, and they are laid out from simple ideas (“Introduction to wait stats”) through more complex. This makes the book a good reference for beginners and professionals. I would highly recommend SQL Wait Stats!

In a recent customer performance trouble shooting exercise they were getting into some sort of slowness in their application. Running couple of queries found some interesting insights into Wait Stats which was nicely explained in a whole chapter for CXPACKET.

More than just a reference this is a practical book on some of the major WAIT STATS which even a novice DBA can also easily understand.

A must buy for any DBA monitoring critical production environments and for those who are into advanced performance tuning.

I want to compliment Pinal and Rick for providing information in such a simple and informative way, the examples used are really helps in understanding the concept very well. I can be used by beginners also.

This book is well written. Great book, filled with very clear presented examples and concepts from general SQL programming.
I would just say this book is great. It provides an excellent explanation of stuff relating things to real world examples. Would highly recommend anyone who wants to understand the SQL!

Pinal Dave and Rick A. Morelan are really a Guru when it comes to SQL!

Just finished reading this book and really loved it. This is the only book I could find, which provides a very detailed explanation of SQL Server Wait types in a very simple and easy-to-understand language. A must have book in every DBA's book shelf.