As with most things, heavy is relative to your app, not an overall distinction.
Look in Books Online for the definitions of the fields, google for any articles or blog posts on the DMV.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability