Consider the following scenario:
Note: Merge Agent profile High Volume Server-to-Server Profile enables parameter -ParallelUploadDownload
In this scenario, you will notice that the merge agent enumerates the already replicated schema changes during each sync operation causing performance problems and other issues.
Cause / Workaround:
The schemaversion column in sysmergesubscriptions table at the subscriber (and publisher) stores the version of the last schema that is received. Due to this issue, this value does not get updated and always points to a version that has already been replicated over to Subscriber during the previous synchronization operation.
You can workaround this issue by either disabling or removing the Merge Agent parameter -ParallelUploadDownload for that subscription. Disabling this parameter causes Merge Agent to update schemaversion to the correct value during next synchronization.
To remove or disable this parameter edit either 'Agent job' or 'Agent Profile' using one of the following procedures that is applicable to your situation:
Note: Merge Agent parameter "-ParallelUploadDownload" is deprecated in SQL Server 2008.