question

salilsingh-9961 avatar image
0 Votes"
salilsingh-9961 asked AlbertoMorillo edited

Azure data sync

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

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@salilsingh-9961 Please let us know if you need further help with this.

0 Votes 0 ·

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.