What is the maximum allowable value of "Max Pool Size" in a connection string?
Suppose this is my connection string in app.config
<add name="Name"
providerName="System.Data.SqlClient"
connectionString="Data Source=ServerName;Network Library=DBMSSOCN;Initial Catalog=DatabaseName;user=UserName;password=Password;Max Pool Size=1024;Pooling=true;"/>
What is the maximum value I can use instead of 1024? Remember it is maximum value, not default value.
Hi, 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.
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).
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.
This may have occurred because all pooled connections were in use and max pool size was reached. When you receive this message, it means that your website is using all of its available SQL Database connections (the default limit is 15 connections per DotNetNuke install).
There is no documented limit on Max Pool Size. There is however an exact documented limit on maximum number of concurrent connections to a single SQL Server (32767 per instance, see http://msdn.microsoft.com/en-us/library/ms143432(v=SQL.90).aspx).
A single ADO.NET pool can only go to a single instance, so maximum effective limit is therefore 32767.
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