Share via

  • Article

SqlConnectionInfo.MaxPoolSize Property

Gets or sets the maximum number of execution threads in a thread pool that the connection will accept.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

'Declaration
Public Property MaxPoolSize As Integer
    Get
    Set
'Usage
Dim instance As SqlConnectionInfo
Dim value As Integer

value = instance.MaxPoolSize

instance.MaxPoolSize = value

public int MaxPoolSize { get; set; }

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

member MaxPoolSize : int with get, set

function get MaxPoolSize () : int
function set MaxPoolSize (value : int)

Property Value

Type: System.Int32
A Int32 value that specifies the maximum number of threads in a thread pool the connection will accept.

Remarks

The default value for this property is 100. This is adequate for most purposes. Modifying the maximum number of threads can improve performance in resource-intensive systems.