ms同步内存不足异常
本文关键字:异常 内存不足 同步 ms | 更新日期: 2023-09-27 18:22:34
我正在尝试同步大小>4GB的sql server数据库。内存不足异常。尝试使用MemoryDataCacheSize&ApplicationTransactionSize。没有成功。这里给出了代码。
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);
}
}
您的进程试图分配过多的内存(这是由MemoryDataCacheSize控制的)。请在此处查看有关您正在尝试做什么的更多信息。