[ACFUG Discuss] CFMX 7 server tuning question

2008-04-29 Thread Fox, Andrew J
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

Re: [ACFUG Discuss] CFMX 7 server tuning question

2008-04-29 Thread Steven Ross
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

RE: [ACFUG Discuss] CFMX 7 server tuning question

2008-04-29 Thread Charlie Arehart
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

RE: [ACFUG Discuss] CFMX 7 server tuning question

2008-04-29 Thread Fox, Andrew J
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