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: 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.

See Also

Reference

SnapshotGenerationAgent Class

Microsoft.SqlServer.Replication Namespace