One of the fine folks from MS who is a customer support Escalation
Engineer, Keith Elmore, has put together a set of Reporting Services
reports that will help DBAs diagnose potential performance problems.
These reports were designed to leverage the new Custom Reports
functionality in SQL Server Management Studio (Service Pack 2).
You can get them here:
SQL Server 2005 Performance Dashboard Reports