Distributor.ThreadPoolSize Property

Article
12/03/2008

Gets or sets the maximum number of threads that the distributor can use to process work items.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property ThreadPoolSize As Integer

public int ThreadPoolSize { get; set; }

public:
property int ThreadPoolSize {
    int get ();
    void set (int value);
}

/** @property */
public int get_ThreadPoolSize ()

/** @property */
public void set_ThreadPoolSize (int value)

public function get ThreadPoolSize () : int

public function set ThreadPoolSize (value : int)

Property Value

A Int32 that specifies the maximum number of distributor threads.

Remarks

The default distributor thread pool size is 3.

The thread pool size determines the degree to which the distributor can perform work in parallel, and affects the overall performance of the Notification Services system.

The distributor thread pool size can be 1, 2, or 3 in Notification Services Standard Edition. The distributor thread pool value is unlimited in other editions. Note that the value represents a maximum; the actual number of threads depends on the availability of system resources.

For more information about how the distributor settings affect distributor operation, see Specifying Distributor Settings.

Example

The following examples show how to create a distributor, define the distributor's properties, and then add it to an application:

// Define distributor for application
Distributor distributor = 
    new Distributor(myApplication, "Distributor");
distributor.SystemName = notificationServicesHost;
distributor.QuantumDuration = new TimeSpan(0, 0, 15);
distributor.ThreadPoolSize = 2;
myApplication.Distributors.Add(distributor);

' Define distributor for application
Dim distributor As Distributor = New Distributor( _
    myApplication, "Distributor")
distributor.SystemName = notificationServicesHost
distributor.QuantumDuration = New TimeSpan(0, 0, 15)
distributor.ThreadPoolSize = 2
myApplication.Distributors.Add(distributor)

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms