My current design is two Mgt servers for some HA (no network yet) and the Ops and DW DB's on separate servers.
But that makes SQL still single point of failure. So should I do Always on for both doubling SQL? Or can I do Always on with just those two, putting a copy of each to the other? OpsDB and DW DB on both? Should one fail, I still have both DB's but the same number of servers? Does that make even sense? :) Is there a point of doing two MgtServers for HA with just one SQL for each DB? -roland
