Dela via

  • Artikel

SnapshotGenerationAgent.MaxBcpThreads Property

Gets or sets the number of bulk copy operations that can be performed in parallel.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)

Syntax

'Declaration
Public Property MaxBcpThreads As Integer
    Get
    Set
'Usage
Dim instance As SnapshotGenerationAgent
Dim value As Integer

value = instance.MaxBcpThreads

instance.MaxBcpThreads = value

public int MaxBcpThreads { get; set; }

public:
virtual property int MaxBcpThreads {
    int get () sealed;
    void set (int value) sealed;
}

abstract MaxBcpThreads : int with get, set
override MaxBcpThreads : int with get, set

final function get MaxBcpThreads () : int
final function set MaxBcpThreads (value : int)

Property Value

Type: System.Int32
An Int32 value that represents the number of parallel threads.

Implements

ISnapshotGenerationAgent.MaxBcpThreads

Remarks

The maximum number of threads and ODBC connections that exist simultaneously is the lesser of the value of MaxBcpThreads or the number of bulk copy requests that appear in the synchronization transaction in the distribution database.

The MaxBcpThreads property must have a value greater than 0 and has no hard-coded upper limit.

The default value of MaxBcpThreads is 1.