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)
ISBN-10: 1906434476
ISBN-13: 978-1906434472


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |