The number of users on our system has recently increased from about 15 to 35, and now the server is hanging 3 or 4 times a day. Server.log reporting that the unrespnsive thread count (see log snippet at end of message).
Have tried paying with the various cfadmin settings, but no joy. There are killer queries that are being executed, and this takes 99% of the CPU for up to 2 minutes - and although the cfserver appears to hang at those times, the response comes back when the query has finished, btu what we are seeing is worse than that - indefinite hangs which can only be cured by stoping and restarting the cf server. We are working to get rid of the killer queries (even if they are not the cause, they should be eliminated in any case), and will probably move the cf server to another machine (currently on the same high spec machine as the databse). Is there anything else we should be doing? Has anyone else experienced these problems? Am running CF 5.0 on RedHat Linux 2.4.2-2smp, UNIX ODBC and Postgres 7.2.3 ----------------------------- Stephen Richards 020 7903 3226 ------------------------------
