CF 5.0 cluster with 5 servers in the farm
MS SQL Server cluster - Raid 10 array connected to both servers with hot fail over
The application gets about 7 million page impressions per day
I want to what the optimal settings should be for data sources settings. In particular Maintain Connections and Timeout settings. Currently maintain connections is set to yes and timeout is set to 5 minutes. But when the SQL server locks up for whatever reason and fails over to the backup server the CF queries just start to queue up. In other words it apears that maintaining connections open by CF some how does not get updated to the newly live box. Before resorting to turing off maintain connections I wanted to know if anyone has had much success with CF and SQL clusters.
-Peter Amiri
[EMAIL PROTECTED]
MySpace.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
