To Joan, Karen, and Catherine, for yesterday, today, and tomorrow
Copyright
Brief Table of Contents
Table of Contents
Preface
Acknowledgements
About this Book
1. Starting the journey
Chapter 1. The Dynamic Management Views gold mine
Chapter 2. Common patterns
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
Index
List of Figures
List of Tables
List of Listings
1.1. What are Dynamic Management Views?
1.1.1. A glimpse into SQL Server’s internal data
1.1.2. Aggregated results
1.1.3. Impact of running DMVs
1.1.4. Part of SQL Server 2005 onward
1.2. The problems DMVs can solve
1.2.1. Diagnosing problems
1.2.2. Performance tuning
1.2.3. Monitoring
1.3. DMV examples
1.3.1. Find your slowest queries
1.3.2. Find those missing indexes
1.3.4. Quickly find a cached plan