An excellent start to using and understanding SQL Server DMV’s and better still it’s available for FREE!!

The pdf book and scripts can be
downloaded from here:
http://www.red-gate.com/community/books/dynamic-management-views