SQL Server basic availability groups should support more than 1 database
SQL Server Basic Availability Group should allow N number of databases to be supported. Currently this feature supports two replica's which is fine, but only support one database to part of the basic availability group. As always-on is strategic offering for availability and has been around since SQL 2012, the basic availability group feature in standard edition should allow more than 1 database. I would suggest N databases or whatever the Always-on technical limit is.
Other database vendors offer such feature outside of enterprise edition.
박민규 (Park, Minkyu) [mcdasa] commented
I 100% agree that Standard Edition should support more than n databases.
We're currently using AG(Standard Edition) for n Database as below
-- N Ag, 1 Listener, N databases
Somehow when we notice H/W failure, we trigger every ag to switch to replica(By Agent Job)
Which is silly.....
Max 2 Replica's and max number of Databases should be whatever the AG max limit is for standard edition.