I have written a chapter-by-chapter review of this book on [...]. the first part of this review follows:
I expected this book to give me an insight into what to do when I get various SQL Server problems. Identify the problem? How do I solve it? And can it give me an understanding as to why it occurred? Did the book fulfil these requirements?
There are two distinct parts to this book, internals and troubleshooting. The first section is more theoretical, and the second is more practical. The aim of the internals section is to provide a deeper background understanding for the subsequent troubleshooting section.
The topics covered are both diverse in terms of subject matter (e.g. hardware, concurrency, extended events) and in terms of the expected level of experience (e.g. PowerShell is introductory, and latches are advanced). Some of the subjects seem a bit off topic (Virtualization), and even esoteric (Spinlocks).
More infor here: [...]