Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Setting up multiple AG's on 1 server Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 11:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 7:00 PM
Points: 34, Visits: 829
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.
Post #1496970
Posted Monday, September 23, 2013 5:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:40 AM
Points: 1,380, Visits: 2,699
e90fleet (9/20/2013)
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.


I am not sure if I need to create one availability group with 3 databases or i can create 3 separate availability groups with 1 database in each availability group


Both configurations will work

As far as performance goes, I haven't tested this enough to determine with setup is best.
Post #1497327
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse