RE: Optimal CF Server settings w/SQL Server Cluster

[Peter Amiri]

Dave thanks for the link to the article. What I'm going to do is keep the Maintain Connection on and set a 5 minute time out. But I'll create a probe that does a simple DB query and set it to run every minute. If the probe fails, I'll recycle the CF server to clear the database connections.


-Peter Amiri
[EMAIL PROTECTED]
MySpace.com

-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 1:21 PM
To: CF-Talk
Subject: RE: Optimal CF Server settings w/SQL Server Cluster

> Dave thanks for the input. My dba tells me that the SQL
> Server cluster is an active-active so your were right in that
> aspect. Do you know why the queries would get queued up after
> a fail-over? Is there any way to force the connections to be
> killed maybe from the database side to force CF to recreate these?

Unfortunately, I don't know that much about SQL Server clustering. According
to this MS article, it's up to the client application to close connections:

http://support.microsoft.com/default.aspx?scid=kb;en-us;273673 <http://support.microsoft.com/default.aspx?scid=kb;en-us;273673&Product=sql2k> &Product=sql2k

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---