AlwaysON Failover Questions I actually have 2 Databases for one application under a SQLServer 2012 ALwaysON,
I want to add another Database for a different application... It is recommended to create a new AlwaysON AG Group?

I would like to know if is possible to have something like this:

AG Group 1
Server 1


DBAPP1(PRIMARY)
DBAPP2(PRIMARY)
DBAPP3(SECONDARY)


AG Group 1
Server 2


DBAPP1(SECONDARY)
DBAPP2(SECONDARY)
DBAPP3(PRIMARY)


Is this possible? Or just dumb?

Thanks!
I don't think so, when you failover you failover the whole AG. So in order to achieve this you'll need another AG. And probably another SQL Server License since you usually only license the active node in an AlwaysOn.