locked
Synchronization is still slow after initial sync RRS feed

  • Question

  • In my application im syncing multiple sql 2008 r2  servers.Its all worked normally but now im getting a slow synchronization on a new 2008 r2 server. i cant find any good reason for that..Even after first two sync its still slow and taking several hours to complete sync.  Thanks in advance..

    SqlSyncProvider RemoteProvider = new SqlSyncProvider(scopename, sqlDestinationConn);
                    SqlSyncProvider LocalProvider = new SqlSyncProvider(scopename, sqlSourceConn);
                    if (sqlDestinationConn.State != ConnectionState.Open && sqlSourceConn.State != ConnectionState.Open)
                    {
                        sqlDestinationConn.Open();
                        sqlSourceConn.Open();
                    }                
                   
                    RemoteProvider.MemoryDataCacheSize = MemorySize;
                    LocalProvider.MemoryDataCacheSize = MemorySize;               
                    RemoteProvider.ApplicationTransactionSize = BatchSize;               
                    RemoteProvider.ChangesApplied += new EventHandler<DbChangesAppliedEventArgs>(RemoteProvider_ChangesApplied);              
                    SyncOrchestrator oOrchestrator = new SyncOrchestrator();               
                    oOrchestrator .RemoteProvider = RemoteProvider;
                    oOrchestrator .LocalProvider = LocalProvider;
                    oOrchestrator .Direction = SyncDirectionOrder.UploadAndDownload;  
        this.SetText("Starting sync.... " + DateTime.Now + Environment.NewLine + textBox3.Text);  
      oOrchestrator .SessionProgress+=new EventHandler<SyncStagedProgressEventArgs>(orch_SessionProgress);     
     ShowStatistics(oOrchestrator.Synchronize());

     


    • Edited by sharon 5656 Wednesday, November 23, 2011 6:29 AM
    Wednesday, November 23, 2011 6:28 AM

All replies

  • does  the newly added server have pre-existing data?

    try registering for the ApplyChangesFailed event to see if there are conflicts/errors encountered applying changes.

    or you can enable Sync Framework Tracing.

    Wednesday, November 23, 2011 6:44 AM