Yes, I think that would probably be the simplest configuration to satisfy your HA need. That alone would improve SCOM availability considerably.
Be advised though. A SQL Cluster is an attractive resource. Once you have one in place, you'll find lots of other uses for it. You may wish to size resources with that in mind. From: [email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Tuesday, August 19, 2014 4:54 AM To: [email protected] Subject: RE: [msmom] SQL Always on? So basically a two node cluster hosting both databases? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Andrew Kunz Sent: Dienstag, 19. August 2014 02:54 To: [email protected]<mailto:[email protected]> Subject: RE: [msmom] SQL Always on? I concur We have clusters at main site with truecopy san replication to a DR site and several redundant MS's ________________________________ From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Subject: RE: [msmom] SQL Always on? Date: Mon, 18 Aug 2014 11:51:02 +0000 Roland, I would suggest a SQL cluster to provide high availability for your SQL DB's. Also, make sure you have a decent SQL backup strategy. We use SQL clustering heavily in our organization for lots of applications. We are currently in the same boat with our SCOM DB's, but we have plans to migrate them to our SQL cluster before too long. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Roland Janus Sent: Monday, August 18, 2014 7:32 AM To: [email protected]<mailto:[email protected]> Subject: [msmom] SQL Always on? 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
