Andy, there's really no substitute for getting a tool like FusionReactor or SeeFusion (or the CF8 monitor if one is on CF8 Enterprise). Not only will they tell you what requests are running (showing you if there's some issue of you hitting a queuing problem of too many requests trying to run at once), but they can also let you view (for each request) exactly what line of code is running (by taking a stack trace). If you see a given request stuck at the same request over repeated stack traces, then there's your clue as to what the problem is.
If you don't see anything jump out, then it could be any of a few other things that may not show up as "stuck requests", whether problems in the web server, or problems due to client variable management, and more. Hope any of these may give you clues. I'll say that if anyone is ever in a pinch and can't resolve such problems and cant' find answers otherwise, I'm available to help you (over the web, with no minimum time requirement and at a reasonable rate). More info at carehart.org/consulting/. Pardon the commercial, but I just realize sometimes people run out of time to tramp around the net looking for solutions. :-) /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fox, Andrew J Sent: Tuesday, April 29, 2008 10:52 AM To: discussion@acfug.org Subject: [ACFUG Discuss] CFMX 7 server tuning question I've got a question about limiting connections for a datasource and overall performance. We've got a production CF server hosting a bunch of apps, a few of which are having heavy loads at the same time. One application in particular seems like it might be causing CF to lock up. It is a student survey app and one professor is having his students fill it out in a lab. We've searched through the CF and Apache logs and don't really see any other suspects. We're running on Solaris 10 and hitting and Oracle 10g database. For this datasource, we have the number of connections restricted to 6. If anyone has any suggestions on other things to check or if something in our setup jumps out as "bad", I'd appreciate the feedback! Andy Fox Systems Analyst III OIT-EIS Georgia Tech ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------