Extra Availability Group or Extra Instance

• fred koene

  Say Hey Kid

  Points: 676

  More actions

  April 3, 2015 at 3:26 am

  #306450

  Hello,

  We have three servers in an Always On AV Group environment, and we want to use two servers for the daily database-work in our company. Off course there will be a penalty when one of the machines is offline, but that's ok with us.

  There are two scenario's:

  1. Create an extra Availability Group which will have its primary role on the second server normally.

  2. Create another instance on all three servers with its own Availability Group.

  Has anyone considered these options before and does anyone have any recommendations as to what option to choose?

  I can imagine there are flexibility considerations, performance considerations, but I can't oversee all implications of it.

  Thanks for any suggestions.

  Fred Koene

• Perry Whittle

  SSC Guru

  Points: 233792

  More actions

  April 3, 2015 at 12:38 pm

  #1788652

  if you have one node down for maintenance you dont need to do anything

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉