This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Ive joined a project which has SCOM and SCSM hosted on SQL Server 2016 Enterprise Edition, with 2 Always On Availability Groups (one for each); including each products DW workloads I believe ..wasn't involved in the original design!).
Customer is looking to down-grade the SQL Server Editions from Enterprise to Standard (as the wrong Edition was used at install time, and the cost of paying for the Enterprise Edition is prohibitive).
I believe we will be limited to 1 database in a SQL Server 2016 Standard Edition Availability Group? and if so, is this possible as a config for SCSM DW databases (aka multiple Always On Groups per SCSM DW databases)??
Curious if others have been through this pain, or can offer some additional thoughts \ insights into likely pain points.. and if indeed its supported.
Many thanks, kind regards
Andrew
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.