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

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

Overview

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.

Product Details

ISBN-13:
9781935182733
Publisher:
Manning Publications Company
Publication date:
05/28/2011
Pages:
375
Product dimensions:
7.30(w) x 9.20(h) x 0.60(d)

Meet 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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >