September 20, 2013 at 11:31 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.
September 23, 2013 at 5:16 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply