I can't believe nobody's mentioned SeeFusion yet... It's not perfect (if the server crashes, you don't really know what happened, although I believe the enterprise version supports odbc logging). The nice thing about it though is that you can go to a page that lists all your running CF pages, and previous requests and long running requests. You can see which queries take the most time and perhaps optimize them, and see which pages are taking a long time to load as well. I believe they have a 3 hour free edition (that works for 3 hours every time you restart CF). Try it out and see if it helps you pinpoint the issue.
-----Original Message----- From: Jennifer Larkin [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 05, 2005 2:52 PM To: CF-Talk Subject: Re: Coldfusion Crashing! Not to disagree greatly with someone who clearly knows what he's talking about better than I do, but there are some problems in tracing log running requests through the log in CF 5. One problem is that if the requests get killed by the "restart after x unresponsive requests" they don't show up in the log as long running requests. The log only tracks long running requests when they finish. If you restart your server too soon, you could end up hiding the problem requests. Turn this setting on but periodically change the timeout setting and see how high you can get it without killing the server. Watch the server closely for a while and see if you can spot any extremely long running requests, then you can deal with those. Another consequence of the long running request problem is that if you have several long running requests in progress, other requests that may not otherwise be long running may show up as long running in the log. If something is listed in the logs as long running, don't determine that the problem is necessarily with that file. What is more important is a pattern of long running requests. If you have a page that is called extremely frequently and only rarely lists as a long running request, the problem is probably not that file. If a file is called rarely and lists as a long running request almost as often, then you have an easily identified problem file. If you have http request monitoring software, generate some per page statistics and then search the CF logs to generate statistics on the pages that you suspect. Also look at timing patterns. If the problem always happens at the start of the work day, something that people do first thing when they get in could be a problem. Check the timing of any scheduled tasks. It's ok for scheduled tasks to run long-- that's one reason to set them up as scheduled tasks. If the problems happen near the time of any scheduled tasks, try moving them and see if the problem continues. Make sure that your scheduled tasks don't overlap. Also make sure that major database tasks such as DTSs run at off-peak hours. If your database is slow, CF will be slow. Good luck! On 7/5/05, Steven Erat <[EMAIL PROTECTED]> wrote: > For the "Request canceled or ignored by server Server busy or unable > to fulfill request" error I would look for bottlenecks in the > application by turning on "Log Slow Pages" and then watch the > server.log for entries, and enable "Restart after X Unresponsive > Requests" and enable a low timeout (15,30,or 60 seconds). Watch the > server.log for this type of entry too (any page exceeding the timeout > will be logged as such in server.log, i.e. 'the unresponsive request > count is up to 1'). > > Bumping up Sim Reqs haphazardly is not a solution. Identify and fix > bottlenecks instead. -- "My mind is a scary place." The Tick Now blogging.... http://www.blivit.org/blog/index.cfm http://www.blivit.org/mr_urc/index.cfm?sectionid=2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211184 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54