Hi - I work at Red Gate, so have an obvious bias here, but just thought I'd mention that we have a new version of SQL Response out very soon, now renamed to SQL Monitor (the tool has been completely re-written for version 2). If you want to have a go yourself, you can download a Beta from:
http://www.red-gate.com/products/sql_monitor_eap/index.htm
It only takes minutes to install and try it out - we'd love to know what you think!
Regards
Ben Rees
Red Gate Software