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)
Syntax
'Declaration
Public Property ApplicationTransactionSize As Long
Get
Set
'Usage
Dim instance As SqlSyncProvider
Dim value As Long
value = instance.ApplicationTransactionSize
instance.ApplicationTransactionSize = value
public long ApplicationTransactionSize { get; set; }
public:
property long long ApplicationTransactionSize {
long long get ();
void set (long long value);
}
member ApplicationTransactionSize : int64 with get, set
function get ApplicationTransactionSize () : long
function set ApplicationTransactionSize (value : long)
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.
Remarks
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.