Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.