cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

aina.rahman
Creator

Hi,

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

 

1 REPLY 1

MARTINA.MELIANA
AppDynamics Team

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.

    Screenshot 2024-07-31 at 10.16.29.png
    Screenshot 2024-07-31 at 10.16.42.png

    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.

    Screenshot 2024-07-31 at 10.17.18.png

    Screenshot 2024-07-31 at 10.18.24.png

    image.png

    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

    StepsSet 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.

    Screenshot 2024-07-31 at 10.27.31.png

    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