My guess is you have a query grabbing an enormous amount of data then trying to process it. That would drive Jrun to 100% and eat up memory. Next time it happens, use the new server monitoring tools in CF8 to find out what scripts are running to try to find the offending page. Also, monitor your DB server to find long running queries.
Setting the server to NOT maintain DB connections is not bad. But you will incur small (millisecond) delays while CF makes the connection to your DB each time it needs to rather than keeping the connection alive. This could become a problem under very heavy usage but is otherwise not very noticable.
Main Topics
Browse All Topics





by: delrundellPosted on 2007-11-07 at 07:07:26ID: 20232733
We went into the administrator and set all our databases to NOT maintaining the database connection. The memory seems to be holding for now. We are watching. Does anyone know if this is a bad thing to do?