Maintenance schedule window on SCOM is not suppressing all SQL 2017 alerts during patching.

Question

Hi Team, Maintenance schedule window on SCOM is not suppressing all SQL alerts.

We are continuously getting below alerts during patching..

The MSDTC Service is stopped and Database is in offline/recovery pending/suspect/emergency state.

We have SQL 2017 version running in our environment, with 2 node Availability groups.

I have added below highlighted objects in Operations manager scheduled maintenance window for both nodes. still not all alerts are getting suppressed. Can we select just one Parent object in the maintenance window which will suppress all alerts?

MSSQL on Windows: Database is in offline/recovery pending/suspect/emergency state (MSSQL on Windows: Database)

MSSQL on Windows: Database Backup Failed To Complete ( MSSQL on Windows: Database)

The MSDTC Service is stopped (MSDTC 2016 Server)

MSSQL Integration Services on Windows: Integration Service Package Failed - Event ID: 12291. (MSSQL on Windows Integration Services: Local Instance)

MSSQL on Windows: Discovery error (MSSQL on Windows: Monitoring Pool Alert Collection)

MSSQL on Windows: DB Engine is in unhealthy state (MSSQL on Windows: DB Engine)

Cluster Role has exceeded its failover threshold: (Windows Server 2016 and 1709+ Monitoring Cluster Service)

Cluster resource group offline or partially online: (Cluster Resource Group)

Answer 1

Your picture/screencap didn't get posted.

When setting up the Maintenance Schedule, you should select the Windows Computer object and then select "Selected objects and all their contained objects" as this will pick up the Server objects (like logical disks) and the SQL objects (DB engine, DBs, etc.)

Answer 2

What objects are you putting into maintenance mode? (your pictures aren't visible)

You should put the Windows Computer object and select "Selected objects and all their contained objects" as this will get the Server object and all SQL objects.