SQL server DMVs in action
Subtitle: better queries with dynamic management views
By: Ian W. Stirk
Publisher: Manning Publications
Published: 2011
Place of publication: Shelter Island, NY
Language: eng
Number of pages: 325
ISBN-13: 9781935182733
Subjects: SQL (Computer program language)
Notes: Includes index.
Table of contents: title: Pt. 1. Starting the journey; title: 1. The Dynamic Management Views gold mine; title: 2.  Common patterns; title: Pt. 2. DMV discovery; title: 3. Index DMVs; title: 4. Improving poor query performance; title: 5. Further query improvements; title: 6. Operating system DMVs; title: 7. Common language runtime DMVs; title: 8. Resolving transaction issues; title: 9. Database-level DMVs; title: 10. The self-healing database; title: 11. Useful scripts