Many system/application monitoring software offer this feature. Using your Cell provider's email -> sms service you can setup something like Nagios to alert you to issues. But I wouldn't consider any of the software 'lightweight' when compared to cacti which itself is fairly lightweight itself.
Hardware and performance
Receive automatic phone call when site is not available
This discussion has been locked so you can no longer reply to it.