question

mbouarroudj avatar image
0 Votes"
mbouarroudj asked mbouarroudj commented

Always On Basic Availability Groups

Hi

In standard version of SQL 2019, can we create multiple Basic availability groups with their own listener? We have 4 independent databases and want to know if we can create 4 basic availability groups, 2 basic AG primary on server A and 2 basic AG primary on Server B ?

Best regards

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered mbouarroudj commented

Hi @mbouarroudj,

Do you know how many Basic availability groups we can create?

Like the traditional (advanced) Always On Availability Groups with Enterprise Edition, Basic Always On availability groups does not have a specific limit on the number of creation.

In theory, there is no limit to the availability groups that can be created on an instance, but generally it is not recommended to exceed 10. Of course, whether more availability groups should be created depends on the possible workload and actual servers configuration.

The differences and limitations of basic availability groups are summarized in following document.
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver15

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you Criszhan

For now we have 4 databases so we need 4 Basic availability groups, Do you know how many Basic availability groups we can create? this is to determine the number of databases that we can host on the same instance

Best regards

0 Votes 0 ·

thanks Criszhan

0 Votes 0 ·

You are welcome. Have a nice day!

0 Votes 0 ·
Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

Hi @mbouarroudj,

In standard version of SQL 2019, can we create multiple Basic availability groups with their own listener?...

Yes, you can. This configuration is completely feasible, just try it.

Best Regards,
Cris

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.