May 2011
Intermediate to advanced
352 pages
11h 27m
English
Welcome to the world of Dynamic Management Views (DMVs). How would you like to fix problems on your SQL Servers with little effort? Or fix problems before they become noticeable by irate users? Would you like to quickly discover the slowest SQL queries on your servers? Or get details of missing indexes that could significantly improve the performance of your queries? All these things and more are easily possible, typically in a matter of seconds, using DMVs.
In a nutshell, DMVs are views on internal SQL Server metadata, and they can be used to significantly improve the performance ...