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
