The best product that I have seen related to performance is Veritas/Symantec's Precise I3 package. There is a bit of a learning curve when it comes to installing and getting the most out of it though.
Another option might be Microsoft Operations Manager.
Michael
<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>