cluster. One of the cluster members experienced hardware problems and it
failed over to another cluster member...and CFMX DB connections hung.
Stace
_____
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: December 1, 2003 4: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&Product=s
ql2k
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]