CODEWITHSUNDEEP
asp.netsql-server
RachitSharma
RachitSharma

Reputation: 589

How many connections (Max.) can be kept in a pool..?

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.

Upvotes: 6

Views: 4203

Answers (3)

RachitSharma
RachitSharma

Reputation: 589

There can be maximum 32767 connections to the database at a time. That is, at a single point of time only 32767 users can make transactions to database via web app. Not even one more than that. A pool size is not mentioned anywhere only default is there(100). But SQL Server will only accept 32767 connections from user. Proof: Select @@MAX_CONNECTIONS . If misunderstood please correct me.

Upvotes: 1

Anup Pal
Anup Pal

Reputation: 1

The user connections option specifies the maximum number of simultaneous user connections that are allowed on an instance of SQL Server. The actual number of user connections allowed also depends on the version of SQL Server that you are using, and also the limits of your application or applications and hardware. SQL Server allows a maximum of 32,767 user connections. Because user connections is a dynamic (self-configuring) option, SQL Server adjusts the maximum number of user connections automatically as needed, up to the maximum value allowable.

Upvotes: 0

Rahul Tripathi
Rahul Tripathi

Reputation: 172418

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

Upvotes: 2

Related Questions