skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Wire Protocol Driver : Connection Option Descriptions : Min Pool Size
  
Min Pool Size
Attribute
MinPoolSize (MNPS)
Purpose
The minimum number of connections that are opened and placed in a connection pool, in addition to the active connection, when the pool is created. The connection pool retains this number of connections, even when some connections exceed their Load Balance Timeout value.
Valid Values
0| x
Behavior
If set to 0, no connections are opened in addition to the current existing connection.
If set to x, the start-up number of connections in the pool is 5 in addition to the current existing connection.
Notes
*This connection option can affect performance.
Example
If set to 5, the start-up number of connections in the pool is 5 in addition to the current existing connection.
Default
0
GUI Tab
Pooling tab
See also
Performance Considerations