SqlSyncProvider::ApplicationTransactionSize Property
Gets or sets the maximum transaction size used during change application, in kilobytes.
Assembly: Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)
public: property long long ApplicationTransactionSize { long long get (); void set (long long value); }
Property Value
Type: System::Int64The maximum transaction size used during change application, in kilobytes. The default value is 0, which indicates no limit on the transaction size.
On a system that restricts the running time or size of a transaction, such as SQL Azure, setting this property to an appropriate value can help to avoid transaction throttling. Use of this feature may incur a performance penalty, however, so it should only be used when necessary.
A typical setting for this value is between 10 megabytes and 50 megabytes. The higher the bandwidth of your network, the higher this value can be. Values of less than 1 megabyte are not recommended because they incur a large performance penalty. Be aware that this value must be larger than the largest possible row in your synchronization scope or synchronization will fail.