Every action in SQL Server – queries, updates, whatever – leaves a set of tiny footprints; SQL Server records all that valuable data and makes it visible through Dynamic Management Views, or DMVs. A DBA or developer can use this incredibly detailed information to significantly improve the performance of queries and better understand what's really going on inside a SQL Server system
SQL Server DMVs in Action is a practical guide that shows how to obtain, interpret, and act on the information captured by DMVs to keep SQL Server in top shape. The 100+ samples provided in this book will help readers master DMVs and also give them a tested, working, and instantly reusable SQL code library.
Who Should Read It
This book is written for DBAs and developers.
What's Inside
- Many practical solutions
- How to correct missing indexes
- What's slowing down your queries
- What's compromising concurrency
- Much more
Book Details
- Paperback: 375 pages
- Publisher: Manning Publications (May 2011)
- Language: English
- ISBN-10: 1935182730
- ISBN-13: 978-1935182733
- File Size: 14.1 MiB
- Hits: 1,883 times
[FileSonic] Manning.SQL.Server.DMVs.in.Action.May.2011.rar
More free ebooks download:
