I have written a chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review follow:
Each recipe in this collection is largely self-contained, making it easy to provide a targeted approach. This is good if you know what you're looking for, but often when you're starting out, you don't. Experience helps, so does reading the whole book.
Each chapter starts with a short introduction to the topic, and contains between three and eight recipes. Each recipe contains sections for: - getting ready - how to do it - how it works - there's more
Most recipes are run against the freely downloadable Adventure Works 2012 database, this makes it easy to follow along with the recipes yourself. Below is a chapter-by-chapter exploration of the topics covered.
Chapter 1 Mastering SQL Trace Using Profiler Although SQL Server Profiler is deprecated, meaning it will be removed from future versions of SQL Server, it is a well known and much used tool for troubleshooting problems. The recipes here walk you through setting up a trace, filtering events, and detecting slow queries - all via the GUI. Additionally, the T-SQL equivalent is also provided. Overall the chapter is easy to read, explains things very well, with more than enough detail to get you started troubleshooting database problems. . . . Conclusion This is a wide-ranging book, with sufficient instruction to get most SQL developers/DBAs started on investigating performance problems. It's a very practical book, typically providing detailed step-by-step walkthroughs for each recipe/topic, and makes good use of screenshots.
There's some nice incidental information provided along with the recipes, and plenty of pointers on where to find further information. Because the topics are largely distinct, there is limited interlinking of recipes/topics.
Although the book purports to relate to SQL Server 2012, much of it is equally applicable to SQL Server 2005 and 2008.
Unfortunately, the book contains several areas of substandard English grammar. If you can tolerate this, the book can be a good read. Personally I think the book's editors should have been fired!
So far, there are only a few books which talk about performance. This is one of the best books I've read. These recipes are used immediately when there are issues with the sql server. The book has pictures along with the steps. Even a novice can easily pick up.
The title says sql 2012. But, most of it applies to SQL 2005/2008. It doesn't discuss the internals of any topic which most of the people may not require. The author does the job nicely.