|SQL Server DMVs in Action
Better Queries with Dynamic Management Views
Ian W. Stirk
May 2011 | 352 pages
|$64.99||pBook + eBook (includes PDF, ePub, and Kindle)|
|$51.99||eBook only (includes PDF, ePub, and Kindle)|
|Browse all our mobile format eBooks.|
SQL Server DMVs in Action is a practical guide that shows you how to obtain, interpret, and act on the information captured by DMVs to keep your system in top shape. The samples provided in this book will help you master DMVs and also give you a tested, working, and instantly reusable SQL code library.
About the Technology
Every action in SQL Server leaves a set of tiny footprints. SQL Server records that valuable data and makes it visible through Dynamic Management Views, or DMVs. You can use this incredibly detailed information to significantly improve the performance of your queries and better understand what's going on inside your SQL Server system.
About the Book
SQL Server DMVs in Action shows you how to obtain, interpret, and act on the information captured by DMVs to keep your system in top shape. The over 100 code examples help you master DMVs and give you an instantly reusable SQL library. You'll also learn to use Dynamic Management Functions (DMFs), which provide further details that enable you to improve your system's performance and health.
Who Should Read It
This book is written for DBAs and developers.
- Many practical solutions
- How to correct missing indexes
- What's slowing down your queries
- What's compromising concurrency
- Much more
About the Author
Ian Stirk is a freelance consultant based in London. He's an expert in SQL Server performance and a fierce advocate for DMVs.
WHAT REVIEWERS ARE SAYING
“If you need to know what is going on in your database server, I highly recommend this book. Already I have had great success resolving some I/O issues that have been plaguing me for some time.”
“Let's face it, if just one of the code samples in this book helps you crack a query performance problem, the book will have earned its keep. It's well written, short on waffle and long on useful info. What more could you ask?”
—Kay Ewbank, I Programmer Reviewer