[SQL] SQL High Availability in MS Azure

I am looking at ways I can mitigate outages during Azure maintainance using SQL stacks in availability groups.

Coming up with an HA architecture for SQL 2012 on Azure threw up the following observations;

I originally considered 3 options for HADR as DB Mirroring, AlwaysOn FCI & AlwaysOn Availability Groups until it became apparent that FCI is reliant on shared storage - doable but certainly a single point of failure as this storage cannot be spread across Azure availability groups.

AlwaysOn Availbility Groups is possible but only through Enterprise licensing which puts a factor of x5 on the monthly run rate.

So unless I've missed something, unless you're prepared to spend the bucks on Enterprise SQL, you are constrained to DB mirroring - have I got this correct ?

Continue reading...