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

aina_rahman — Tue, 07 Nov 2023 06:58:58 GMT

Hi,

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

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

MARTINA_MELIAN1 — Wed, 31 Jul 2024 04:46:19 GMT

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:

Enable the Email Server if not yet set up.
steps to Enable the Email Server
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:

.NET Agent Extension
.NET Agent extension to monitor windows services. Reference: .NET Agent Extension Documentation
Write your own Machine Agent Extension
Machine Agent for custom monitoring of services.　Reference: Machine Agent Documentation

Hope this help.

Regards,

Martina

topic Re: How do I setup an email alert for a particular server when the SQL Server & SQL Agent services is down? in Splunk AppDynamics

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

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

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