Re: Database keeps killing our MX Servers
DataDirect3.3 from MM for Oracle. -Adam - Original Message - From: Donnie Bachan <[EMAIL PROTECTED]> Date: Fri, 03 Sep 2004 16:38:59 -0400 Subject: RE: Database keeps killing our MX Servers To: CF-Talk <[EMAIL PROTECTED]> What drivers are you using? We have had success with the Microsoft JDBC drivers for SQL Server 2000. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Database keeps killing our MX Servers
What drivers are you using? We have had success with the Microsoft JDBC drivers for SQL Server 2000. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database keeps killing our MX Servers
Well I can speak from experience that the timeouts you can define on CF's side (datasource, page request, tread) will do nothing if CF is waiting for a database response. CF will just wait forever. -Adam - Original Message - From: Stacey Robertson <[EMAIL PROTECTED]> Date: Fri, 3 Sep 2004 15:21:41 -0400 Subject: Database keeps killing our MX Servers To: CF-Talk <[EMAIL PROTECTED]> We're having a recurring problem where our MX server keeps hanging. We have a datasource for an SQL database. Two seperate MX servers have datasource connections to this same database. Periodically, the SQL server will start blocking all requests. (This is something else that we are looking into) When the blocking starts to happen on the db, the web requests hang as they are waiting for their request to go through. At first, we did not have a timeout on the queries and without fail, both MX servers would hang to such an extent that they were essentially dead in the water. To try and fix this situation, we have set a timeout on all db requests. We have set the timeout to 60 seconds. We had hoped that this would solve the situation, but we have just experienced the same problem again even with the timeout specified. Has anyone here seen this issue in the past? If yes, how did you resolve it? Any input would be greatly appreciated as we are really at our wits end with this! ___ Stacey Robertson Supervisor, Web Development & Reporting NSB Group Tel: (514) 426-0822 x2078 Fax: (514) 426-0824 [EMAIL PROTECTED] http://www.nsbgroup.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Database keeps killing our MX Servers
We're having a recurring problem where our MX server keeps hanging. We have a datasource for an SQL database. Two seperate MX servers have datasource connections to this same database. Periodically, the SQL server will start blocking all requests. (This is something else that we are looking into) When the blocking starts to happen on the db, the web requests hang as they are waiting for their request to go through. At first, we did not have a timeout on the queries and without fail, both MX servers would hang to such an extent that they were essentially dead in the water. To try and fix this situation, we have set a timeout on all db requests. We have set the timeout to 60 seconds. We had hoped that this would solve the situation, but we have just experienced the same problem again even with the timeout specified. Has anyone here seen this issue in the past? If yes, how did you resolve it? Any input would be greatly appreciated as we are really at our wits end with this! ___ Stacey Robertson Supervisor, Web Development & Reporting NSB Group Tel: (514) 426-0822 x2078 Fax: (514) 426-0824 [EMAIL PROTECTED] http://www.nsbgroup.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
