I found Performance Tuning with SQL Server Dynamic Management Views by Tim Ford and Louis Davidson really really helpful.
I have the paperback edition and I was looking for the online version to avoid typing the sample queries.The entire book and many more are available for free download.Happy reading!
