meaning of max pool size ?

[Plausible Indirection]

I'm having a hard time finding something explicit which indicates
whether Max Pool Size is intended to mean 'maximum number of
connections within a pool, where distinct connection strings means
distinct pools' or 'maximum total number of connections which can be
pooled, regardless of how many different strings have resulted in
different pools'.

Can anyone clarify this for me? The former seems to make more sense.

Thanks,
Chris

 

[William \(Bill\) Vaughn]

Max Pool Size determines how many connections will be kept open (once
opened) in the pool. Generally, a normally loaded system should use about a
dozen connections. If a connection string is different than any existing
pooled string, a new pool is created. Each pool contains connections with
identical connection strings. If you change the connection string each time,
you'll get a new pool each time.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Pablo Castro [MS]]

It's the former one: maximum number of connections in a given pool (the one
this connection string is associated with). Other pools can have other
connections, there is no knob to control the total number of connections
across all connection pools.

--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.