Re: [ACFUG Discuss] CFMX 7 server tuning question
I have seen one situation with oracle and cf 7 (on solaris) with maintain connections ticked in the admin. It looks like CF can't tell when oracle drops the connection and then it tries to use that connection again and an error is thrown in the logs. I haven't seen it lock up a server or anything like that. Also you said that your limiting connections, are you doing this to help out the DB server? is there an issue there? Decreasing the connections may cause the server to start queuing requests (which may appear as a lockup to the user, however, the server should come back with responses eventually). Another thought on maintain connections, it could be with all your apps that coldfusion is competing with itself to get connections to the db server and is waiting in peak times for connections to open up. Really though, there are a bunch of unknowns here that may require you to put something like seefusion or the like on the server so you can really see what exactly is going on. -Steven On Tue, Apr 29, 2008 at 10:51 AM, Fox, Andrew J [EMAIL PROTECTED] wrote: 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 - -- Steven Ross web application interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] (404) 592-6885 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - 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 -
RE: [ACFUG Discuss] CFMX 7 server tuning question
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 -
RE: [ACFUG Discuss] CFMX 7 server tuning question
Thanks for the quick responses! We're in the process of getting CF8 Enterprise installed and migrating to it. I think we're probably going to end up keeping an eye on the reset switch (metaphorically) until we get moved to 8. If we do get stuck, I'll ask my management if they'd be willing to spring for some help! Andy _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: Tuesday, April 29, 2008 1:00 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFMX 7 server tuning question 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 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 -
