How do I setup an email alert for a particular server when the SQL Server & SQL Agent services is down?

[aina_rahman]

Hi,

What are the steps for setting up an email alert when SQL Server and SQL Agent services is down?

[MARTINA_MELIAN1]

Hi @aina.rahman ,

Thank you for posting on community. To monitor the SQL Server and SQL Agent services and set up email alerts when they are down,
you can follow these steps:

1. Enable the Email Server if not yet set up.
    steps to  Enable the Email Server

2. Set up Related Health Rules, Policies, and Actions to Monitor Services

   for SQL Server Monitoring, utilize AppDynamics Database Agent:
   Install Database Agent
   Monitor Databases and Database Servers
   Steps:
   Set Health Rule: On Controller > Databases > Alert & Respond, configure a health rule. Use the metric DB|KPI|Database Availability to monitor whether the SQL Server is running.

   
    

    

   Set Policies: Policies: On Controller > Alert & Respond > Policies, create a new policy. Set the Trigger, Health Rule Scope, and Actions. Add action and configure email to specify where to send alert emails.

   

    

   

    

   
   

   By following these steps, I received email alerts when health rules are violated (SQL server down/SQL server stopped).
   
   
   for SQL Server Agent Monitoring, utilize AppDynamics Machine Agent. AppDynamics Machine Agent can monitor processes on server.
   Machine Agent
   Server Process Metrics
   
   Steps: Set up health rule, policy, and action similarly to the database agent above. Notes: When setting up the health rules, under Affected Entities, select Custom Health Rule Type to set process metrics such as memory usage or count in the Critical/Warning area.
   
   
   
   By following these steps, I received email alerts when the SQL Agent service is down.

Other Monitoring Alternatives

Below are some possible alternatives to monitor your windows services status:

1. .NET Agent Extension
   .NET Agent extension to monitor windows services. Reference: .NET Agent Extension Documentation

2. Write your own Machine Agent Extension
   Machine Agent for custom monitoring of services.　Reference: Machine Agent Documentation

Hope this help.

Regards,

Martina