SQL Services Not Alerting When Stopped
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 7.0.0.0 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 7.0.15.0 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:7.0.0.0 we're not getting alerts generated when a respective Automatic SQL Service is stopped.
Thanks,
Jason