Wednesday, January 15, 2003, 4:26:21 PM, you wrote: IL> Hi all, IL> We've got a server that's suddenly become very cranky - running slowly, IL> hanging, etc. 3-4 times per day.
When you say hanging, do you mean the CF process, or the entire machine? If the entire machine is locking, then it's probably not a software issue at all, or it's a Windows problem. What does the CPU load look like before it crashes? IL> The hosting company told us that we should: IL> 1. Uncheck 'maintain database connections' for all ODBC datasources. This is flat wrong for anything other than Access, and performance will suffer greatly. Maybe it would help isolate an odd odbc driver issue but that seems unlikely. IL> 2. Only use OLE DB for MSSQL datasources. MS has been trying to push the world to OLEDB for a while now. Other than that, I can't say. IL> Both of these seem counterintuitive to me - OLE DB is buggy as all get IL> out, and I've always been told that 'maintain database connections' is IL> a performance enhancer, not a drag. IL> We're using CF 4.5.1 - traffic levels are about what they've always IL> been, and all session/app vars are appropriately locked. IL> Any input? Have you examined the logs to see if anything obvious jumps out, like on template in particular running before the crash, or a particular template hanging a thread consistently? Usually I need both the web logs and the cf logs side by side to get a good picture of what is going on. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4