Acknowledgements

 

I’d like to start off by thanking the whole Manning team, in particular Katharine Osborne, Michael Stephens, Marjan Bace, Mary Piergies, Janet Vail, Linda Recktenwald, Katie Tennant, and Dennis Dalinnik. Thank you, Katharine, for your professionalism and steering me in the right direction, and thank you Michael and Marjan for believing the subject of DMVs could make an important contribution to improving SQL performance. I’m indebted to the Manning production team, Mary, Janet, Linda, Katie, and Dennis, for guiding me through the production process and helping make this a better book.

I’d like to express my thanks to Elvira Chierkoet, for checking and reading every sentence and helping ensure my ideas were sensible.

To the technical reviewers, I want to thank you for your feedback and for making this a more accurate book: Tariq Ahmed, Christian Siegers, Nikander Bruggeman, Margriet Bruggeman, Amos Bannister, Richard Siddaway, Sumit Pal, Dave Corun, and Sanchet Dighe, and special thanks to the main technical reviewer, Deepak Vohra.

I want to give a special thank-you to Karen Stirk, Catherine Stirk, and Charlie for their support and encouragement. A special thank-you is owed to my grandparents, Joan and Bill Bridgewater, and the rest of the Bridgewater family (Karen, Timmy, Brenda, Caroline, Kenny, Patty, Jenny, Mary, Jacky, David, and Diane). And thanks also to my old chemistry teacher, Jim Galbraith. Without these people, I would have turned out a lesser person.

About this Book

Who should read this book?

Roadmap

Code conventions and downloads

Author Online

About the author

About the cover illustration

Part 1. Starting the journey

Chapter 1. The Dynamic Management Views gold mine

1.1. What are Dynamic Management Views?

1.2. The problems DMVs can solve

1.3. DMV examples

1.4. Preparing to use DMVs

1.5. DMV companions

1.6. Working with DMVs

1.7. Summary