SCOM 2022 DB design

Question

We are looking to upgrade our SCOM DB Ops and DW DB clusters. We currently have 2 physical clusters with 2 nodes each. One cluster to support the Ops DB and the other supports the DW DB. I am wondering if a 3-node cluster (Active/Active/Passive) would be a supported configuration. I can't seem to find anything online.

thanks

Answer 1

Hi,

The Operations Manager database is a single source of failure for the management group, so it can be made highly available using supported failover configurations such as SQL Server Always On Availability Groups or Failover Cluster Instances.

https://learn.microsoft.com/en-us/system-center/scom/plan-sqlserver-design?view=sc-om-2022#operations-manager-database

If you're hosting the database on a SQL Server cluster, replace computername with the virtual network name of the SQL cluster resource group. If the database is part of a SQL Always On Availability Group, replace computername\instancename with the availability group listener name in the format of AvalabilityGroupListenerName,portNumber.

https://learn.microsoft.com/en-us/system-center/scom/manage-sqlserver-communication?view=sc-om-2022