SQL Server DMVs in Action: Better Queries with Dynamic Management Views (Paperback)

Ian W. Stirk

  • 出版商: Manning
  • 出版日期: 2011-05-16
  • 定價: $2,145
  • 售價: 9.5$2,038
  • 語言: 英文
  • 頁數: 375
  • 裝訂: Paperback
  • ISBN: 1935182730
  • ISBN-13: 9781935182733
  • 相關分類: MSSQLSQL
  • 立即出貨 (庫存=1)




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.


每個在 SQL Server 中的操作 - 查詢、更新等等 - 都會留下一組微小的腳印;SQL Server 會記錄所有這些有價值的資料,並透過動態管理檢視(Dynamic Management Views, DMVs)將其呈現出來。資料庫管理員(DBA)或開發人員可以使用這些極其詳細的資訊,顯著提升查詢的效能,並更好地了解 SQL Server 系統內部的實際情況。

《SQL Server DMVs in Action》是一本實用指南,展示如何獲取、解讀和利用 DMVs 所捕獲的資訊,以保持 SQL Server 的最佳狀態。本書提供了100多個範例,將幫助讀者掌握 DMVs,同時提供一個經過測試、可立即重複使用的 SQL 代碼庫。