CODEWITHSUNDEEP
c#synchronization
user3244326
user3244326

Reputation: 41

ms sync out of memory exception

I'm trying to sync sql server database having size > 4GB. Getting Out of memory exception. Tried with MemoryDataCacheSize & ApplicationTransactionSize . No success. The code is given here.

    public static long BatchSize = 500000;
    public static uint MemorySize = 4000000000;
    public void Sync(ServerSyncHelper server)
    {
        try
        {
            SqlConnection clientConn = DBConnection;
            SqlConnection serverConn = server.DBConnection;
            SyncOrchestrator syncOrchestrator = new SyncOrchestrator();
            var localProvider = new SqlSyncProvider(ScopeName, clientConn);
            localProvider.MemoryDataCacheSize = MemorySize;
            localProvider.ApplicationTransactionSize = BatchSize;
            syncOrchestrator.LocalProvider = localProvider;
            var remoteProvider = new SqlSyncProvider(server.ScopeName, serverConn);

            remoteProvider.ApplicationTransactionSize = BatchSize;
            remoteProvider.MemoryDataCacheSize = MemorySize;
            remoteProvider.ChangesApplied += new EventHandler<DbChangesAppliedEventArgs>(RemoteProvider_ChangesApplied);
            syncOrchestrator.RemoteProvider = remoteProvider;
            syncOrchestrator.Direction = SyncDirectionOrder.UploadAndDownload;
            ((SqlSyncProvider)syncOrchestrator.LocalProvider).ApplyChangeFailed += new EventHandler<DbApplyChangeFailedEventArgs>(ApplyChangeFailed);
            SyncOperationStatistics syncStats = syncOrchestrator.Synchronize();
            LogWriter.Write("Start Time: " + syncStats.SyncStartTime);
            LogWriter.Write("Total Changes Uploaded: " + syncStats.UploadChangesTotal);
            LogWriter.Write("Complete Time: " + syncStats.SyncEndTime);
        }
        catch (Exception ex)
        {
            LogWriter.Write(ex);
        }
    }

Upvotes: 0

Views: 365

Answers (1)

Lawrence McAlpin
Lawrence McAlpin

Reputation: 2785

Your process is trying to allocate too much memory (this is controlled by the MemoryDataCacheSize). Look here for more information on what you are trying to do.

Upvotes: 2

Related Questions