SCOM 2022 DB design

Bryan, TJ 0 Reputation points
2023-03-02T14:52:51.9666667+00:00

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

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
853 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. XinGuo-MSFT 14,856 Reputation points
    2023-03-06T09:16:07.0633333+00:00

    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

    0 comments No comments