Azure SQL Data Sync No Response

Question

Hi, I started to run Azure SQL Data Sync No Response from Azure SQL Database to another SQL Database in the same Azure SQL Server, however, it found that the Sync State no response for more than 2 days, there is no any new data insert or process, the Status still show Processing, what should I do? Thanks Alan

Answer 1

@Alan Chan Admin 100 million records is a lot of records for an Initial Sync. Since there is data on the source database, as well as the target database, Data Sync will undergo a row-by-row conflict resolution process which is very slow. What I suggest is  

1. Remove the tables/large tables from the Sync Schema.
2. Truncate the tables/large tables on the target database.
3. Add the tables/target tables to the Sync Schema.
4. Sync.   By doing the above steps, you will be asking Data Sync to BULK INSERT the 100 million records from the source database tables/large table to the target database tables/large table, directly. Since there would be zero rows in the tables/large table on the target database, there would not conflicts, and BULK INSERT will happen. Please let me know if you still have any issues.

Regards

Geetha

Answer 2

During the initial sync is better to scale up the service tier of the databases to the most you can.

If you can consider configuring the sync from scratch (here you will find a tutorial), I suggest you start the sync with an empty database on the member database to make the process finish faster. You can disable the account you use for the sync process to stop the initial sync, if you are not able to stop it.