中文名: 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