DMVs are views on SQL Server metadata, which can be used to improve the performance of your SQL queries. In this article, Ian Stirk, author of SQL Server DMVs in Action, describes how DMVs can help fix common SQL issues.

Welcome to the Dynamic Management Views Goldmine (PDF)