Azure data sync

Question

Hi Team,

In Azure Portal, while doing the Azure data sync between on-premises SQL Server db and Azure SQL db, processing is very slow and is taking lots of time to do the sync processing.
Apart from upgrading the configuration of Azure SQL dbs, is there any other option through which this processing speed could be increased?

Thanks,
Salil

Answer 1

On the initial sync, SQLData Sync won't know the two databases are identical until it compares the data row by row. It is a very costly process and may take a long time and a lot of resources if you have large databases/tables. Our recommendation is to have data only on one side and keep the same table empty in the other databases. In this case, data sync will use bulk load during initialization and it is much faster than row by row comparison.

Performance is improved if your SQL Data Sync server and sync group hub are located in the same region (data center). Provision a SQL Data Sync server in each data center that will host a sync group hub.

Design to avoid synchronization loops. A synchronization loop results when there are circular references within a sync group so that each change in one database is replicated through the databases in the sync group circularly and endlessly. Any row that is synchronized by one sync group cannot be synchronized by another sync group. You want to avoid synchronization loops as they degrade performance and can significantly increase your costs.