Max Pool Size question

[fniles]

When using connection pooling, I understand the default Max Pool Size = 100.
What happens when to the 101 or more connection ? I mean, if 101st tries to
use the connection pooling, what happen to it ?
Will it get an error ?
Thank you.

 

[Marina Levit [MVP]]

Yes, you will get an exception with the message that the connection pool is
out of available connections.

 

[Patrice]

AFAIK it will first wait to see if one becomes available and then you'll get
an exception if the wait reaches a timeout value.

Also double check your app before changing this value (the idea behind
pooling is to open/close connections as needed allowing to sahre 100
connections nbetweeen a much higher number of users).

 

[William \(Bill\) Vaughn]

See my MSDN article on connection pooling. If you're trying to increate the
pool size, you have some serious issues. This is like putting a tachometer
in a car that goes up to 15,000 RPM hoping it will help get more revs out of
the engine. http://www.betav.com/msdn_magazine.htm


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
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.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Cor Ligthert [MVP]]

. This is like putting a tachometer
in a car that goes up to 15,000 RPM hoping it will help get more revs out
of the engine.

Good one I will use it in future if you don't mind.



Cor