I am looking for a way to monitor and alert our DBA's when one of the sql services, msdtc, sqlserver, sqlagent, etc. stops. I have set up a custom property for the said services on our sql servers and have very successfully begun monitoring. I would like, and need, a simple and effective way to set up an alert to e-mail our DBA's when 1 of the services on a sql server goes down. My efforts so far produce 240 e-mails (1 for each service on each sql server) when only 1 service on 1 server goes down. I know one way to do it is to create 80 alerts (1 for each server) but cannot bring myself to accept that it is the only way. Any ideas out there?
Mike
