How to solve false alert "SQL Server Agent Service is not running" generated for an application server and a file server?

Question

Hi All,

We get "<SCOM2019> Alert: SQL Server Agent Service is not running Resolution state: New" false alert email notification for a File server / application server in our SCOM 2019 environment. However, it has also been noticed that the alerts didn't generate for a genuine SQL server where the SQL server services were actually stopped.

I would appreciate your help in this regard.

Thanks in advance

Nishant

Answer 1

Hi,

It sounds like you’re dealing with a false positive alert in your SCOM 2019 environment. This can be quite frustrating. Here are a few steps you can take to troubleshoot and resolve this issue:

1. Check the Service Status: Verify if the SQL Server Agent Service is actually running on the server. Sometimes, the service might be running, but SCOM might not be able to detect it due to network or permission issues.
2. Review the Management Pack: Ensure that the management pack responsible for monitoring the SQL Server Agent Service is correctly configured and up to date. Sometimes, outdated or misconfigured management packs can cause false alerts.
3. Alert Suppression: You can configure alert suppression to prevent multiple alerts for the same issue. This involves setting up rules to suppress alerts that are generated repeatedly for the same condition.
4. Override the Monitor: If the alert is being generated by a specific monitor, you can override the monitor settings to adjust the sensitivity or frequency of the checks. This can help reduce false positives.