Max Pool Size question

  • Thread starter Thread starter fniles
  • Start date Start date
F

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.
 
Yes, you will get an exception with the message that the connection pool is
out of available connections.
 
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).
 
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)
 
. 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.
Click to expand...

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

:-)

Cor
 
Back
Top