SQL Server Dashboard issue - Objects incorrectly listed as In Maintenance Mode

Christian 61 Reputation points
2021-04-28T08:31:07.17+00:00

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

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,481 questions
0 comments No comments
{count} votes

7 answers

Sort by: Most helpful
  1. CyrAz 5,181 Reputation points
    2021-04-28T08:54:19.293+00:00

    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...

    0 comments No comments

  2. 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?


  3. 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?

    0 comments No comments

  4. Christian 61 Reputation points
    2021-04-28T15:08:09.183+00:00

    92183-ads2.png92166-ads.png


  5. 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.

    92519-image.png

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.