We want to switch an SAP SQL database cluster to SQL Availability Groups. The plan is to have two replica servers in the same data center with synchronous commits, and one in the DR location with Asynchronous commits set.
The concern I have is this database cluster has very high transactions and is always busy. Could we suffer from a performance standpoint?
Is there a way where we can determine if this database will suffer or not based on some metrics we can evaluate beforehand, such as the number of transactions...etc.?