Best Practices for Dynamic Management Views – George Heynen

  Overview   Dynamic Management Views (DMVs) were a giant leap forward for SQL Server in the 2005 release.   DMVs provide a simple and familiar relational interface for gathering critical system information from your SQL Server.   This document will focus on a handful of DMVs that I have found most useful for isolating performance issues….