For more full monitoring, Red Gate, SQL Sentry and others have products that will do it. They monitor a whole lot more than just performance. They aren't free, but they include an awful lot of stuff you might not think of.

When it comes down to fixing things, I haven't seen anything beat an old-fashioned review and fix of the bad code. The monitoring will help you find it.