[SQL.Server.DMVs.实战].(SQL.Server.DMVs.in.Action)

中文名: SQL Server DMVs 实战 原名: SQL Server DMVs in Action: Better Queries with Dynamic Management Views 作者: Ian W. Stirk 资源格式: PDF 版本: 英文文字版/更新源代码 出版社: Manning书号: 9781935182733发行时间: 2011年05月 地区: 美国 语言: 英文 简介: 内容介绍： 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. 目录: Part 1 Starting the journey Chapter 1 The Dynamic Management Views gold mine Chapter 2 Common patterns Part 2 DMV discovery Chapter 3 Index DMVs Chapter 4 Improving poor query performance Chapter 5 Further query improvements Chapter 6 Operating system DMVs Chapter 7 Common Language Runtime DMVs Chapter 8 Resolving transaction issues Chapter 9 Database-level DMVs Chapter 10 The self-healing database Chapter 11 Useful scripts