I was searching for some query to get information from my DWH without me having actually access, i found a set of pretty heavily commented queries that are very useful for detecting and diagnosing many common performance issues with SQL Server 2008 created by Glenn Berry
Check them here:
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2015.entry