We have been seeing a similar problem. A couple of weeks ago we put our
site on a pair of dedicated servers, one running windows 2000/CF4.5 and the
other is SQL Server 2000. I was noticing that over time that CF Server was
gradually chewing up more and more RAM without letting it go. Restarting
the Cold Fusion service freed up the memory, but it would just climb again.
I changed a lot of the settings in CF Server, such as reducing the amount
of time and the number of pages and queries that will be held in cache, but
it did not make any appreciable difference.
Once we restarted, the CF memory usage would be down around 10 mB, but if
someone ran a query with no filtering criteria and the entire recordset was
returned, it would spike up to 150 mB immediately, and never go down. The
code is pretty streamlined, and the cpu usage averages around 5% with
periodic spikes up to 50 or 60% for a few milliseconds. I've only seen it
max out (512 mB) once or twice, and it drops again very quickly. There is
fairly high traffic on our site, with approximately 10,000 visitors per day.
Limiting the number of records returned did a lot to reduce the amount of
RAM used by CFServer, but it still creeps up over time. When I have seen
the RAM usage climb up over 200 mB or so I execute a DOS command, 'kill
cfserver', which stops and then automatically restarts Cold Fusion Server.
I haven't found a real explanation or solution for this, so any insight
would be appreciated.
Philip Hunter
Director - Internet Technology
The Ag Dealer
www.agdealer.com
Tel: (613) 596-8022
Cell: (613) 223-7299
Fax: (613) 596-8088
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
