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: Tuesday, April 29, 2008 1:06 PM
To: discussion@acfug.org
Subject: 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 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

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
is a pre-defined query for this already.  If using Toad, there is a view for
this too, though I can't recall where.  You will need permissions to the
appropriate v$ tables.

DK

On Tue, Apr 29, 2008 at 12:28 PM, Steven Ross <[EMAIL PROTECTED]> wrote:

> 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 
> > -
>
>
>
>
> --
> 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 FusionLink 
> -
>



-- 
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?



-
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

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

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

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




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

[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 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 http://www.fusionlink.com
-