Skip to main content
K
Karvin
Participant
August 31, 2010
Question

Number of concurrent DB connections in CF 9 Pro ed.

  • August 31, 2010
  • 1 reply
  • 601 views

I am running CF 9 Prof on Windows 2003, with sql server 2005. I am running a web application that has total has about 350 users on at peak connecting to about 40 different data sources. At peak times I will get several errors in a row of Timed out trying to establish connection. It seems to run fine until this starts to happen.

Until recently we were splitting the clients between 2 cf boxes and this was never an issue.

I am wondering which direction to look in.

Is this an issue of too many different connections to db's for Pro ed. to handle.

Is there a limit of db connections in Pro Ed. I have searched this forum and googled it and can't seem to find an answer.

Thanks,

    This topic has been closed for replies.

    1 reply

    J
    JR__Bob__Dobbs
    Inspiring
    August 31, 2010

    Questions / Things to Check:

    1. Is there any information related to this issue in the SQL Server or Windows logs that might point to a problem outside ColdFusion?

    2. Check your data source settings.  What are the values for "Limit Connections", "Restrict Connections To", and "Maintain Connections"?  Could these settings be limiting the number of connections?
    http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe5.html

    3. Can you provide the full error message?

    Adobe Technote: "How are database connections handled in ColdFusion?"
    http://go.adobe.com/kb/ts_tn_18061_en-us

    K
    KarvinAuthor
    Participant
    September 1, 2010

    I am looking into the 1st question and will let you know when I have any answers there.

    the 2nd question is I am limiting the connections for each db to 6, I am maintaining the connection, and I set the timeout to 20 minutes with a 1 minute check. On my previous server setup with 2 cf servers I had the connction limit at 4, and I never got this problem. the other servers were CF 8 however.

    The error coming through is [Datasource] is Not Available .Timed out trying to establish connection.

    The only reason that I limit connections is that previous version of CF would sometimes grab a thread and never let it go, I didn't want all my clients down at once so I limited how many threads any 1 db could take.  I don't know if that issue was ever solved in 9.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices