Connection Pooling

  • Thread starter Thread starter Thomas Tryde
  • Start date Start date
T

Thomas Tryde

SqlConnection("connection-string to a database")

If I have one web application using this connection-string
then I will have up to 100 connections.

If I on another computer have two web applications using
the same connection-string, how many connections will I
have pooled? -100 for each web application or do they share
the connections?
 
Is there anyone who have a link or something where
connection pooling is described in details?

TT
 
¤ SqlConnection("connection-string to a database")
¤
¤ If I have one web application using this connection-string
¤ then I will have up to 100 connections.
¤
¤ If I on another computer have two web applications using
¤ the same connection-string, how many connections will I
¤ have pooled? -100 for each web application or do they share
¤ the connections?

A connection pool is created per process and per connection string. So, if you are connecting via a
web application then connections will pooled as long as each connection request uses an identical
connection string.

Connections are created and destroyed as they are requested and as they time out respectively.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top