8

In connection string to SQL Server there is max pool size option. My question is where is this connection pool managed and maintained - on .net side or on server side?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
ren
  • 3,843
  • 9
  • 50
  • 95

2 Answers2

5

Pool is maintained on the client side. So every client will create physical and logical connections. Physical connection is expensive to create, logical is not. User code directly works with logical connections using ***Connection (for example SqlConnection) classes. So when you dispose a connection you actually return a physical connection to a pool.

On the other side it is also possible to configure max allowed connections on the server side, thus server can make a crude load-balancing by denying some connections.

oleksii
  • 35,458
  • 16
  • 93
  • 163
1

The Pool is on the Client-side (.NET).

You're right that is not spelled out in many places but it clearly follows form the way it is configured and how it operates.

H H
  • 263,252
  • 30
  • 330
  • 514