What is maximum allowable value of "Max Pool Size" in sql connection string

Question

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.

I think this falls into the category of "if you have to ask, you're probably doing something wrong" - why do you think you need so many connections open? — Damien_The_Unbeliever, Dec 22 '11 at 11:19
It is a web seo application with 100,000 users gathering various types of data. And failure is not an option. — Syed Salman Akbar, Dec 22 '11 at 13:29
Most sites need far fewer connections to the database than the number of users. And failure is always a possibility you have to plan for anyway. — Damien_The_Unbeliever, Dec 22 '11 at 13:39

score 19 · Accepted Answer · answered Dec 24 '11 at 10:01

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.

score 4 · Answer 2 · answered Dec 22 '11 at 11:00

4

As far as I know - 32767 This is the limit of Sql Server, not .NET

answered Dec 22 '11 at 11:00

Oleg Dok

21,109
4
45
54

you said what i was able to confirm later. – Syed Salman Akbar Dec 24 '11 at 10:02

score 0 · Answer 3 · answered Dec 22 '11 at 10:27

0

You may check with DBA connection limit set in database server

answered Dec 22 '11 at 10:27

Brijesh Mishra

2,738
1
21
36

What is maximum allowable value of "Max Pool Size" in sql connection string

3 Answers3

Linked