RE: [ACFUG Discuss] CFMX 7 server tuning question

2008-04-29 Thread Charlie Arehart
Well, just to be clear, you can use the trial editions of FusionReactor or SeeFusion right now, for free. That seems a lot better than just waiting for things to die or be reset. Hope that's helpful. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fox, Andrew J Sent:

Re: [ACFUG Discuss] CFMX 7 server tuning question

2008-04-29 Thread Douglas Knudsen
Also, you can query your Oracle DB to get the currently open connections. Look here to see if your limit of 6 connections for that particular user is getting hit often indicating many issues one of which could be not enough connections for your load. If you are using Oracle's SQL Developer, there

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 spr

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 onc

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

[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 s