I have installed SQL Server 2012
Clustered HA with Replica in Sync mode between two nodes connected by an high-speed VPN. The DB is encrypted. Everything works fine, but to do the replication, the HA system takes a lot of time.
The DB is made up of 90 tables of which only 10 are fast-moving. The average for the 10 tables is equal to 100,000 records. The others have from 1,000 to 25,000 records. Can you explain to me what is due to the slowness?
The Primary Server how often starts the synchronization mechanism with Secondary and the Secondary how often start the same sync with Primary server (I have chosen MASTER-MASTER HA replica)?