SQL Server DMVs in Action

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.3. Identify what SQL statements are running now

1.3.4. Quickly find a cached plan

1.4. Preparing to use DMVs

1.4.1. Permissions

1.4.2. Clearing DMVs

1.5. DMV companions

1.5.1. Catalog ...