Performance Tuning with SQL Server Dynamic Management Views
Since SQL Server 2005, dynamic management views and functions have complemented, extended, and replaced the options by which DBAs and developers could get insights into the internal workings of SQL Server. However, these Dynamic Management Objects (DMO) seem not to be as widely adopted as one would expect after almost six years ago.
It’s well beyond the scope of this review to look for possible reasons of this, but one might be the absence of secondary literature. This gap now has finally been closed with the publication of Performance Tuning with SQL Server Dynamic Management Views by Louis Davidson and Tim Ford. To the best of my knowledge it is the first book that focuses exclusively on DMOs. To make it clear right from the outset this is a very good book!
Not only does the reader learn how to use the DMOs to replace familiar oldies such as “sysprocesses”, but also how to gain new insights into things that were hard to get before SQL Server 2005, if possible at all such as information about the usage of indexes or where and why SQL Server is waiting for resources.
These topics are very well covered in the book. Further topics cover spotting locking and blocking, analyzing index fragmentation, and investigating caching and execution plan re-usage.
High-quality content, numerous code samples and a very attractive price make a purchase decision quite easy.
Performance Tuning with SQL Server Dynamic Management Views (High Performance SQL Server)
Louis Davidson, Tim Ford
Red Gate Books (September 2010)