What is the maximum and minimum size of connection

问题:

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]

回答1:

Default Max Pool Size 100

Min Pool Size 0

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

回答2:

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

回答3:

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

回答4:

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://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers