Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
11-06-2023 10:58 PM - last edited on 11-09-2023 09:38 AM by Ryan.Paredez
07-30-2024 09:46 PM
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
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form