How to find out the max connection pool size

[Bob]

One of my web applications throws a SqlConnection exception occationally,
with the message saying unable to obtain a connection, and it may be due to
max connection pool size has been reached and there is no more connection
available. How can I find out (and change?) the max connection pool size?

Thanks
Bob

 

[SqlJunkies User]

This usually happens when you fail to close your connections (often overlooked when using DataReaders). So i would go through your code and ensure that all methods close connections.

 

[Patrice Scribe]

Add a "max pool size" entry in the connection string :
http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/connectionpooling.aspx

That said you may still want to check wether or not you have leaked
connections (for example if using a connection layer, it's quite easy in
debug mode to "register" somewhere each connection so that you can check
they are all released at the end so that you can be warned during the
development phase).

Patrice

 

[Bob]

Thanks a lot guys. I'm aware that there are some code scrutiny I need to
do. And the URL below gives straightforward code to set the pool size
explicitly. Any way to find out the default pool size when it's not set
explocitly? There must be a default value.

Thanks again
Bob

 

[Patrice Scribe]

Forgot this part. AFAIK the default is 100, likely enough in most cases ?

Patrice

--

 

[Bob]

Think I found it, the default is 100 for SQL provider,
http://msdn.microsoft.com/library/d...nectionpoolingforsqlservernetdataprovider.asp