Programming Books C Java PHP Python Learn more Browse Programming Books

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $2.66 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

SQL Server DMVs in Action: Better Queries with Dynamic Management Views [Paperback]

by Ian W. Stirk
5.0 out of 5 stars  See all reviews (3 customer reviews)

List Price: $64.99
Price: $46.10 & FREE Shipping. Details
You Save: $18.89 (29%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 2 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it Monday, April 28? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

May 16, 2011 1935182730 978-1935182733 1

Every action in SQL Server - queries, updates, whatever - leaves a set of tiny footprints; SQL Server records all that valuable data and makes it visible through Dynamic Management Views, or DMVs. A DBA or developer can use this incredibly detailed information to significantly improve the performance of queries and better understand what's really going on inside a SQL Server system

SQL Server DMVs in Action is a practical guide that shows how to obtain, interpret, and act on the information captured by DMVs to keep SQL Server in top shape. The 100+ samples provided in this book will help readers master DMVs and also give them a tested, working, and instantly reusable SQL code library.

Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

Frequently Bought Together

SQL Server DMVs in Action: Better Queries with Dynamic Management Views + Performance Tuning with SQL Server Dynamic Management Views (High Performance SQL Server) + SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)
Price for all three: $104.55

Buy the selected items together

Editorial Reviews

About the Author

Ian Stirk is a freelance consultant based in London. He's a world-class expert in SQL Server performance and a fierce advocate for DMVs.

Product Details

  • Paperback: 375 pages
  • Publisher: Manning Publications; 1 edition (May 16, 2011)
  • Language: English
  • ISBN-10: 1935182730
  • ISBN-13: 978-1935182733
  • Product Dimensions: 9.2 x 7.2 x 0.7 inches
  • Shipping Weight: 1.4 pounds (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Best Sellers Rank: #500,149 in Books (See Top 100 in Books)

More About the Author

My current skill base is largely centred on SQL Server, with a speciality in performance. Additionally, I keep up to date with what's happening in the C#/.NET world. I'm also interested in some of the newer technologies, particularly Mobile, Big Data, Social Media, and future trends. I've worked in IT since 1987, so covered a lot of ground: Mainframes, Minis, PCs, Internet, and coded in more than 12 different languages.

In the course of my work I often create new software utilities, and when possible I author articles on these utilities to share with others. Additionally, I'm a technical reviewer of books and magazines. I've also written a well-received SQL Server performance book SQL Server DMVs in Action: I feel it is important to give something back to the industry that provides me with a living.

On a final note, I'm a freelance consultant, and I'm available to help improve the performance of your SQL Servers/C#. You can contact me for availability and cost at

* SQL Server Performance
* .NET/C# Performance
* SQL Server/C# development

Customer Reviews

5.0 out of 5 stars
5.0 out of 5 stars
4 star
3 star
2 star
1 star
Share your thoughts with other customers
Most Helpful Customer Reviews
5 of 5 people found the following review helpful
By Jose
Format:Paperback|Verified Purchase
This book is fantastic. It is not my 1st DMV book, I actually own Performance Tuning with SQL Server Dynamic Management Views (High Performance Sql Server), but I consider this one a better book, without saying the other one is bad either. The reason for that is that this book has a better layout and it is easier to follow. The code snippets are more practical too, in my opinion. This book helped me to troubleshoot (and improve) several slow queries the same day I bought it.

What I prefer or like of this book is the layout and logic. It would make more sense if you read from start to end, but you can even jump into an specific chapter and start taking benefit from it. You will need a basic understanding of T-SQL, but the explanations are clear and easy to follow. It helps that they also show the screen-shoots of the query results and they even provide further explanation of the code snippet itself, like what line is doing what, the reason for using CROSS APPLY, etc.

DMVs are not new, they were 1st introduced on SQL2005 couple of years ago, but combine them via JOINS can be a very complex task. I've been creating my own code snippets for quite a while but these two books actually go beyond from giving you a simple code and they teach you something.

By the way, there is no Kindle version of this book at the time of my review, but when you buy the regular paper book, you later can download the ebook version on three different formats, and they are free: PDF, ePub and Mobi, that's a nice deal! I have my own hard copy at home, and downloaded the PDF version on my work's PC. Be aware that some of the code snippets are difficult to read on a Kindle 3 though, so better if you use an iPad of Kindle DXG for that.
Read more ›
Was this review helpful to you?
5.0 out of 5 stars Best SQL Book August 13, 2013
This is one of the BEST Books about SQL Server ever written. Goes beyond just DMV you get to understand some of the internals of SQL
Comment | 
Was this review helpful to you?
1 of 2 people found the following review helpful
5.0 out of 5 stars DMZ for SQL Server July 20, 2011
By bob
Format:Paperback|Verified Purchase
This is an excellent book for getting up to speed with SQL Server Dynamic Management Views. This book is a very valuable reference.
Comment | 
Was this review helpful to you?
Search Customer Reviews
Only search this product's reviews

What Other Items Do Customers Buy After Viewing This Item?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category