Menu
What is the maximum and minimum size of connection pool ADO.Net Supports in the connection string.
Min Pool Size=[max size ?]
Max Pool Size=[min size]
237
A connection pool is created for each unique connection string. When a pool is created, multiple connection objects are created and added to the pool so that the minimum pool size requirement is satisfied. Connections are added to the pool as needed, up to the maximum pool size specified (100 is the default).
By default, SQL Server allows a maximum of 32767 concurrent connections which is the maximum number of users that can simultaneously log in to the SQL server instance.
Min Pool Size: Minimum number of connections maintained in the pool. The default is 0. Pooling: When true, the connection is drawn from the appropriate pool, or if necessary, created and added to the appropriate pool.
To set the maximum pool size: n is the number of connections allowed per pool, from 1 to 2,147,483,647 (the default). The number of connections is limited by the number of connections supported by your database driver.
Default Max Pool Size 100
Min Pool Size 0
Connection Pooling for the .NET Framework Data Provider for SQL Server
102
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
