I just had a look at an environment with approximately 1000 databases and none of them shows "in maintenance mode" in the summary dashboard, and I can't say I've ever witnessed such a behavior...
SQL Server Dashboard issue - Objects incorrectly listed as In Maintenance Mode
Hi there,
I noticed that lots of objects (databases) in the Microsoft SQL Server | Summary dashboard (widget) are listed as in Maintenance Mode while they are not. I am using v7.0.24.0 of the Microsoft SQL Server on Windows MP and v7.0.28.0 of the Microsoft SQL Server Visualization Library MP.
It also happens when you create a dashboard yourself with the respective SQL Datacenter Dashboard template (widget).
Is this a known issue?
Regards,
Chris
7 answers
Sort by: Most helpful
-
-
Christian 61 Reputation points
2021-04-28T10:48:58.183+00:00 I am using SCOM 2019 UR3. What is your platform and SQL MP version?
-
Christian 61 Reputation points
2021-04-28T14:11:19.293+00:00 Strange. I tried it on another system with same MP versions, but same problem there. When I add Virtual or normal Groups myself it shows the same problem: e.g. Virtual Group based on the Active Directory Domain Controller class.
For several classes even all instances are shown as In Maintenance.
I've already flushed MS Health Service Agents and restarted MS SDK and Config Service.
Any idea?
-
-
Christian 61 Reputation points
2021-04-29T09:06:58.15+00:00 It's a dashboard created with the SQL Datacenter Dashboard template (widget) from the SQL MP.