Do you want to outsource this service, or install you own solution?
I use Nagios sucessfully for a large webfarm. It is easy to configure, flexible and easy to expand when needed, and you can configure it to performe active actions on certain triggers, like restart your apache or mysql on specific high load events.