Very nice article!
Readers can discover a lot more about improving SQL performance via DMVs in this recently published book "SQL Server DMVs in Action" www.manning.com/stirk
. It contains more than 100 scripts to identify problems, and offers a wide range of solutions.
Chapters 1 and 3 can be downloaded for free. Chapter 1 includes scripts for:
A simple monitor
Finding your slowest queries
Find your missing indexes
Identifying what SQL is running now
Quickly find a cached plan