We have Windows Server 2016 machines with SQL server 2016 standard edition. Currently mirroring is implemented and now are planning to move to HA with 1 listener for each DB. We have multiple DB's
In few DB stored procedure we have call to other DB with hardcode name.
Once we move to HA with 1 listener for each DB, will this new configuration be any issue for me?
Best Answer
Since you are on standard edition - you will be using Basic Always On availability groups for a single database.
The only issue that I see is that you have to failover all the interrelated databases together (since your app has cross db calls e.g. joins, etc).
I don't see any other issues except the limitations highlighted here.