Setting up multiple AG's on 1 server

  • 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.

  • 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