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

by Ian W. Stirk

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.

375 pages, Paperback

First published May 13, 2011

Reviews

[Jim Clouse · Rating 3 out of 5]

I'm torn on how many stars to give this book. The fundamentals of dmvs and SQL optimization are great. So are the queries the author provides. However there is a ridiculous amount of duplication. The book could have been narrowed down to 50 pages, IMO.

[Christophe Addinquy · Rating 3 out of 5]

ma note de lecture en français ici