Setting up multiple AG's on 1 server

Last Post 22 Sep 2013 11:27 AM by rm. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
e90fleet
New Member
New Member

--
21 Sep 2013 06:45 AM
Hi all, question for you please:

i am upgrading sql from 2008 to 2012 and on one instance we have 3 databases setup with mirroring.
The plan is to use AAG but i am not sure if i need to create one availabilty group with 3 databases or i can create 3 separate availabilty groups with 1 database in each availability group.
What will be disadvantages/advantages with creating 3 separate availabilty groups with 1 database in each availability group? how about performance and
server resources? it is used more resources when you have more AG's on the instance opposed to just 1?
This AG will be setup as synchronous with auto failover.

The reason why i am thinking to setup 3 separate availabilty groups with 1 database in each availability group is because
if for some reason the database is not in synchronous mode i can easily remove replica until the problem is solved for just 1 database instead of 3.
rm
New Member
New Member

--
21 Sep 2013 12:56 PM
If you like to swing all three dbs together, should put them in single AV group. Otherwise use separate AV groups. By the way, AV group is not required if just mirror db to another server.
e90fleet
New Member
New Member

--
21 Sep 2013 02:06 PM
Thank you rm, yes, it works, and this isntance will work as HA solution with auto failover.
But what you whould do? 3 db's in 1 ag, or 1 to 1 relationship?
i am wondering which solution is better for performance and easy maintenance.
rm
New Member
New Member

--
22 Sep 2013 11:27 AM
As I said do you like all 3 dbs are live on same serve all the time? If that's the case, you should put 3 dbs in single AV group.
You are not authorized to post a reply.

Acceptable Use Policy