Azure data sync

salilsingh-9961 346 Reputation points
2021-04-05T12:24:21.327+00:00

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
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 33,961 Reputation points MVP
    2021-04-05T13:11:34.477+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.