Check out this article [/url]and this article[/url].
Additionally, you should check out this tool which creates a performance data warehouse off your DMV information. Note it takes up some space.
Another tool that I have not used yet is SQL Nexus but I hope to soon.
Hope this gives you some things to look at.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot