SQL Server DMVs in Action

05/24/2011 · No Responses

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.

Who Should Read It
This book is written for DBAs and developers.

What’s Inside

Many practical solutions
How to correct missing indexes
What’s slowing down your queries
What’s compromising concurrency
Much more

Table of Contents
Part 1: Starting the journey
Chapter 1. The Dynamic Management Views gold mine
Chapter 2. Common patterns

Part 2: DMV discovery
Chapter 3. Index DMVs
Chapter 4. Improving poor query performance
Chapter 5. Further query improvements
Chapter 6. Operating system DMVs
Chapter 7. Common Language Runtime DMVs
Chapter 8. Resolving transaction issues
Chapter 9. Database-level DMVs
Chapter 10. The self-healing database
Chapter 11. Useful scripts