How many connections (Max.) can be kept in a pool..?
asp.net, sql-server
Solution
There is no such document where you can find the maximum size of the pool.Default value of max pool size is `100`
Check out MSDN
Problem
How does connection pooling works? i want to know that if i set max. pool size = 20 so are only 20 users able to connect to the web app. at a same time and make a transaction ? What happens to the large websites like Amazon where thousands of users log in at same time throughout the world i.e what pool size do they keep? i am not getting the core concept. I know that a connection pool keeps open connections and users reuse the open connections but i want my first question to be answered.