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

Question

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

Answer 1

@Christian , Thanks for letting us know the location. Based on my test, I find my DC is in healthy state without maintenance. I will monitor more to see if it will be accidently put into maintenance mode.

On the other hand, we can do SQL query to check the maintenance mode for the server.

dbo.MaintenanceMode.[User] as [User],  
Case ReasonCode  
When 0 then 'Other (Planned)'  
When 1 then 'Other (Unplanned)'  
When 2 then 'Hardware: Maintenance (Planned)'  
When 3 then 'Hardware: Maintenance (Unplanned)'  
When 4 then 'Hardware: Installation (Planned)'  
When 5 then 'Hardware: Installation (Unplanned)'  
When 6 then 'Operating System: Reconfiguration (Planned)'  
When 7 then 'Operating System: Reconfiguration (Unplanned)'  
When 8 then 'Application: Maintenance (Planned)'  
When 9 then 'Application: Maintenance (Unplanned)'  
When 10 then 'Application: Installation (Planned)'  
When 11 then 'Application: Unresponsiv'  
When 12 then 'Application: Unstable'  
When 13 then 'Security issue'  
When 14 then 'Loss of network connectivity (Unplanned)'  
End as [Reason for Maintenance]  
  
FROM BaseManagedEntity INNER JOIN  
MaintenanceMode ON BaseManagedEntity.BaseManagedEntityId = MaintenanceMode.BaseManagedEntityId  

We can also use "Get-SCOMMaintenanceMode" to confirm if the server is really in maintenance mode:

Hope it can help.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

They are not in maintanance mode.

I also see that the Alert Parameters in Alert Names are not resolved in this dashboard: Shows {0} and {1} while this works in the normal Alert View.

Also down-drilling does not work properly: Some instances have containment relationships with other instances but no children are shown.