Has anyone seen their CF server do this in the Performance Monitor? http://www.newgency.com/ryans/perfmon.gif
For some reason the Queued requests just grows and grows, but it seems that nothing is being processed, then all of a sudden the server springs back to life and starts processing pages. While this is going on, the website just hangs.
The CPU utilisation is below 20% and there is heaps (ha ha) of memory available... what could be the cause of these strange freezes?
The profile suggests that all the CF working threads are hung (or processing long running taks). The threads kick back into operation likely because you have set a timeout for threads in the administrator, ie. the threads get timed-out, recover and start processing again.
You essentially have a severe bottleneck somewhere -- judging by the low resource utilisation that is going to be external to the box. At a guess I'd say the database.
If this only happens intermittently then it may simply be one or two bad pages -- and someone decides to refresh them half a dozen times when they get no response, throwing the server into a flap-spin. Well you can live in hope.
Classic scenarios involve things like very open SQL searches doing LIKE across 10,000's of records.
Try increasing your server timeout a bit (temporarily), log slow running pages and see if you can't pinpoint the bad code quickly. Failing that your best option is to start profiling the SQL statements being executed.
-- geoff http://www.daemon.com.au/
--- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
