Max Pool Size question

5 Dec 2006 4:12 PM

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.

5 Dec 2006 4:22 PM

Marina Levit [MVP]

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

Show quoteHide quote

"fniles" <fni***@pfmail.com> wrote in message
news:uVOrThIGHHA.3304@TK2MSFTNGP05.phx.gbl...
> 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.
>

5 Dec 2006 5:11 PM

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).

--
Patrice

--

"fniles" <fni***@pfmail.com> a écrit dans le message de news:

uVOrThIGHHA.3***@TK2MSFTNGP05.phx.gbl...
Show quoteHide quote

> 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.
>

5 Dec 2006 5:15 PM

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)
-----------------------------------------------------------------------------------------------------------------------

Show quoteHide quote

"fniles" <fni***@pfmail.com> wrote in message
news:uVOrThIGHHA.3304@TK2MSFTNGP05.phx.gbl...
> 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.
>

5 Dec 2006 7:59 PM

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