use NETIQ. we use it for monitoring stuff. Also IBM Tivoli is helpful. Or check this:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ServiceStatusMon&referringTitle=AutomatedDBA