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

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

作者: Ian W. Stirk
出版社: Manning
出版在: 2011-05-16
ISBN-13: 9781935182733
ISBN-10: 1935182730
裝訂格式: Paperback
總頁數: 375 頁





內容描述


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.




相關書籍

Oracle Database 12c Security (Paperback)

作者 Scott Gaetjen David Knox William Maroulis

2011-05-16

Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

作者 Heller Jon

2011-05-16

Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control

作者 Porus Homi Havewala

2011-05-16







2
2
2