If I'm using connection pooling in my application, is there some way I can
tell if there are no more connections available? Can I control the number?
Are there performance implications ?

Thanks in advance.
Valerie Hough

Valerie,

By default, I believe the pool size is 100.  If the limit is reached, then
your request gets queued until a connection is available.  The performance
implications, the obvious one anyways, would be the delay during the queue
period.

You can control the pool size number in your connection string, use the Max
Pool Size property.

HTH
Altaf

--------------------------------------------------------------------------------
All that glitters has a high refractive index.
www.mendhak.com


Show quoteHide quote

Thank you very much.

It's worth to note that it's likely caused in most cases by unreleased
connections. You may want to double check this is not caused by your
application before solving the problem by increasing this value...

Show quoteHide quote

Yes. You can use the Performance Counters exposed by the .NET Framework.
However, these are not particularly reliable. They are replaced by new
counters in 2.0. Can you control the number? Understand that a heavily used
site consumes about 20-50 connections. If 100 is not enough you have a
problem. Sure, there are performance implications--each live connection
consumes CPU resources and limits the overall number of connections the
server can support.

Show quoteHide quote

Iterating through selects - what is the best approach?
multithreaded grid-binding problems
How to Insert a whole dataset into database
Connection string information
Memory usage increases with ADO.NET v2.0 RTM