THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Book: SQL Server DMVs in Action

A while ago, I was offered to have an early look at the book "SQL Server DMVs in Action" (by Ian W. Stirk). This morning, I received a copy (in electronic form) from Manning Publications of the book. So I jumped straight into the book, and here are some thoughts from a quick first look:

DMVs were introduced in SQL Server 2005, and I felt this was one of the most important new manageability features of that release. I guess I'm not alone in the feeling that I should spend more time learning these DMVs, but other things always come in between. This is why I was interested by a book focusing on this pretty narrow topic. Basically, what I want is a cookbok of DMVs I can use for various situations. Sure, we can surf the net for these things, but it is so ... fragmented. A book can, if done right, give us some context and elaborations. And, hopefully, one place to look - for various situations.

I'm happy to say that this book seems to have this structure. The book has a couple of introduction chapters (valuable for those less familar with the DMV concept) and then we have one chapter for each important part (index, execution plans, OS, transaction etc). Basically, we have sub-topics (and one or more query) named something like "Find the most important missing indexes", "Finding the queries taking the longest time to run", etc.. You get the picture.

So far, I only had a brief look, trying a couple of queries. I like the topic and how the book is structured. You can find out more about it at

Published Tuesday, September 21, 2010 2:42 PM by TiborKaraszi
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



chenyingying said:


May 6, 2018 10:47 PM

linying123 said:


May 10, 2018 8:08 PM

Leave a Comment


This Blog


Privacy Statement