How to set Number connections for connection pooling

Posted on 2004-08-20
Medium Priority
Last Modified: 2010-04-06

iam getting the below error if iam trying to access my web site. This web site is running on Windows 2000 server and Database is MS SQL 2000.

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

In IIS, i had configuered number of connections to unlimited. Is there any other place to set the same and what is the minimum and maximum number of connections we can set.

Question by:mohanvamsi_g
  • 2

Accepted Solution

MGrassman earned 100 total points
ID: 11850888
If you are using Visual Studio.net 2003, and maybe other versions also, you can follow this link and that seems to be the fix.


Hope that helps.


Expert Comment

ID: 11850896
One more thing make sure you close all objects that were created and not being used any more.

set cn = nothing

set rs = nothing

Assisted Solution

jay_eire earned 100 total points
ID: 11863219
Hi Mohan
you can run Performance Monitor to see exactly what is happening with you connection pool ;

Connections Currently Active: The current number of connections being used by applications.
Connections Currently Free: The current number of connections available for connection requests.
Connections Sec/Hard: The number of connections made to data sources per second.
Connections Sec/Soft: The number of connections from the pool per second.
Disconnections Sec/Hard: The number of disconnects made to data sources per second.
Disconnections Sec/Soft: The number of disconnects from the pool per second

This TECH NET document will show you how to set it up

The maximum amount of Threads in a pool depends on the power of your web server; If you are using ASP by default the number of  threads per processor is set at 10 . Here are some excellent TECH NET documents on  Monitoring and Fine Tuning Your Server http://www.microsoft.com/windows2000/techinfo/reskit/en-us/default.asp?url=/windows2000/techinfo/reskit/en-us/iisbook/c05_preventing_processor_bottlenecks.asp

From what I ember you can use IIS Administration Kit to really fine tune your web server, you can increase decease the number of threads available per processor.

Jay Eire

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question