SQL Services Not Alerting When Stopped

Jason Steeves 136 Reputation points

We're running SCOM 2012R2 and have noticed that when our SQL Servers have their services stopped that they're not generating an Alert in the SCOM Console, even though the management pack is setup for this. We're currently running SCOM Server 2016 MP and this is discovering our SQL servers / databases / agents / etc successfully. We've also checked and there's no overides for the respective SQL Services ie (SQL Server Agent Windows Service).

We've also ensured that in our testing the Startup was set to Automatic as otherwise the alerts would not be generated.

In a lab environment the SQL 2016 was loaded on a SCOM 2019 server and we were able to successfully generate an alert once the sql service had stopped.

Please advise why in SCOM 2012R2 with SQL 2016MP: we're not getting alerts generated when a respective Automatic SQL Service is stopped.



Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,419 questions
0 comments No comments
{count} votes