September 22, 2020 at 8:13 pm
Hello experts,
Does anyone know why SCOM (or is it SCCM?) would send the following alert when everything is OK and green in the Always On High Availability > Show Dashboard?
The Metric is: Microsoft.SQLServer.Windows.Monitor.Database.DBStatus (UnitMonitor)
MSSQL on Windows: Database is in offline/recovery pending/suspect/emergency state
The databases in each AG are also online and synchronized so I see no issue there either.
If this is a real issue that needs to be resolved, perhaps someone can advise. Or, if this is a false positive based on a SCOM setting, that would be very helpful, too.
Thanks for any help.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 23, 2020 at 4:05 pm
Hi webrunner,
You may want to go under Management\Extended Events\Sessions\AlwaysOn_health in SSMS and view target data on the package0.event_file and check for any state changes around the SCOM Alert time frame. If there was a change this could have tripped the SCOM alert.
Hope this helps!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply