Connection Pooling.

[Axcontrols2]

I understand the reason for connection pooling.

But how is the pool managed? If a user starts more than one instance of my application does each instance of the application have its own private pool or is the pooled shared between instances.

What about if multiple users are running the application in an RDP server. Are all instances totally separate or could they be sharing the same connection pool?

Thanks guys

[PlausiblyDamp]

I imagine part of this depends on the underlying database / provider...

Pooling would normally not be done between applications, therefore if you had multiple apps (or multiple instances due to RDP etc) then you would have a separate pool for each server.

Pooling would normally also be tied to the user identity used to connect to the database, allowing different users to share a single connection would play havoc with the security model of any database!

https://learn.microsoft.com/en-us/do...ection-pooling explains how it works for SQL server, just as a point of interest.

[Niya]

From the link posted by PD above:-

Connections are pooled per process, per application domain, per connection string and when integrated security is used, per Windows identity. Connection strings must also be an exact match; keywords supplied in a different order for the same connection will be pooled separately.

[sapator]

I don't see 'MARS' in that article.
Is something that can be taken in consideration. https://learn.microsoft.com/en-us/do...ve-result-sets
I'm seeing a web config we have that states: MultipleActiveResultSets=True;Pooling=False , I'm sure we had some pooling issues that is why we deactivated it but I can't be sure when and why. Would worth if someone has some insights.