Export (0) Print
Expand All

SqlSyncProvider.ApplicationTransactionSize Property

Gets or sets the maximum transaction size used during change application, in kilobytes.

Namespace:  Microsoft.Synchronization.Data.SqlServer
Assembly:  Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)

public long ApplicationTransactionSize { get; set; }

Property Value

Type: System.Int64
The 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.

Show:
© 2014 Microsoft