Embarcadero looks way to involved to setup, and I'm not sure I like the idea of using agents.

Idera's SQL diagnostic manager seems like the way to go...