Philip - thanks for the assist. I did find the problem - a query result set
was being stored in a *session* variable. Of course, it's one of those
"SELECT * FROM" queries. Each session was carrying about 1 meg of data.
Ack...
Looks like I have some work to do :)
Thanks,
Jeff
---------------------------
Jeff Beer
Senior Programmer Architect
Hydrogen Media, Inc
(727) 530-5500 x303
[EMAIL PROTECTED]
> -----Original Message-----
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 08, 2001 10:24 AM
> To: CF-Talk
> Subject: RE: CF Virtual memory usage
>
>
> Oops, maybe I should read the whole message more thoroughly
>
> Check with how much cache you've put into things in the Admin
> - if it's too
> small then CF will spend a lot of time swapping things into and out of
> memory
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
> > -----Original Message-----
> > From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> > Sent: 08 March 2001 15:04
> > To: CF-Talk
> > Subject: RE: CF Virtual memory usage
> >
> >
> > > Does anyone have any idea if CF Server should be holding
> virtual memory?
> > > This morning the server is still handling requests, but
> the memory stats
> > > are:
> > >
> > > Memory Usage: 90.6 megs
> > > Peak mem usage: 149.1 megs
> > > Virtual Memory: 173.6 megs (!)
> > > Handles: 1,654
> > >
> > > I ran perfmon all day yesterday and never saw more than
> three running
> > > requests, no queued requests and no timed out requests.
> > >
> > > CF seems to be extremely stable and performing well.
> However, at some
> > > point, we get the "server busy" error.
> > >
> > > I'm stumped - does anyone have any further troubleshooting tips?
> > >
> > > Once again, it's CF 4.5.2 pro, with MDAC 2.5 SP1 on Win2k
> server. It's
> > > currently using ODBC. We will be moving it to OLE DB next week.
> >
> > Template cache, query cache, variables, current queries...
> loads of other
> > stuff
> >
> > Philip Arnold
> > Director
> > Certified ColdFusion Developer
> > ASP Multimedia Limited
> > T: +44 (0)20 8680 1133
> >
> > "Websites for the real world"
> >
> >
> **********************************************************************
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error
> please notify
> > the system manager.
> >
> **********************************************************************
> >
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
