22

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]

Saurabh
  • 5,661
  • 2
  • 26
  • 32

4 Answers4

20

Default Max Pool Size 100

Min Pool Size 0

Connection Pooling for the .NET Framework Data Provider for SQL Server

Muhammad Akhtar
  • 51,913
  • 37
  • 138
  • 191
  • 5
    @Saurabh Pool size has both max and min, the default max is 100 and default min is 0. So your comment "It is default size not max" is wrong and misleading. – Sharjeel Ahmed Nov 03 '14 at 18:28
  • @monotheist - The point that was being made is that its the "Default maximum", not "actual maximum". So, this highest voted answer does not answer the question – StingyJack Nov 01 '16 at 21:13
19

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.

Min pool size is zero

Syed Salman Akbar
  • 767
  • 2
  • 8
  • 19
  • 2
    I think you need to be clear that this is the MAX POOL SIZE and not the default MAX POOL SIZE. The Default MAX POOL SIZE is 100, but you can increase this to the maximum allowed by the database you are connecting to. – cmdematos Oct 30 '14 at 20:13
  • 1
    The link in this answer is broken, here is a working one: http://msdn.microsoft.com/en-us/library/ms143432 – Dan Ling Apr 11 '17 at 21:18
5

Default value of max pool size is 100 and min pool size is 0

Mahesh KP
  • 6,248
  • 13
  • 50
  • 71
1

The Default Connection Pool Size is 100 . You can increase the pool size using 'Max Pool Size' property in the connection string. for example - Max Pool Size=1000;

If you are using the Azure SQL server, the number of concurrent connection will depends on SQL Server Tier that you are using.

Please refer the link for more information - https://learn.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers

Venkataraja Medarametla
  • 11
  • 1