I wrote this article a couple of years ago (back in 2003) - so I was wondering why I was getting emails on this all of the sudden!

Anyhow - SQL Server 2005 DMV and DMFs are definitely the way to go moving forward.