Dedication

To Joan, Karen, and Catherine, for yesterday, today, and tomorrow

Brief Table of Contents

 

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

Table of Contents

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

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