I have written a detailed review of this book on "www i-programmer info" the first part of this review follows:
This short book aims to give you an understanding of wait stats, what they are, and how they can be used to improve SQL performance. Does it succeed?
When you submit a query to SQL Server, it runs on the CPU, however, if it can't run for any reason (e.g. waiting to get data from disk), SQL Server records why the query couldn't run, internally as a wait state (commonly known as wait stats). Examining these wait stats can reveal why a given SQL Server instance is performing sub-optimally.
Using wait stats together with performance monitor (PerfMon) counters to investigate problems on SQL Server is a well known performance tuning technique. This book aims to provide a guide to the more common wait stats, the techniques involved in using them, and offers advice on how to reduce them to improve SQL performance.
I expected the book to start with an overview of what Dynamic Management Views (DMVs) are, so as to put the wait stats DMV into context, but it doesn't, instead it starts with an analogy about inventions. Most chapters have a similar format, firstly explaining some common related wait stats, their causes, and methods used to reduce them. Each chapter ends with a review of the chapter's content and a short quiz - both of these are short and enjoyable. The wait stats and the methods used to reduce them are explained adequately.
The wait stats examined include: