1. Move your client variable store from Registry to an ODBC/OLEDB/native datasource - necessary tables are generated automatically when you switch to the datasource - we use SQL Server7 for this.

2. Limit simultaneous requests to say 5 per CPU **and** set resart on unresponsive threads to < this limit, say 3.

3. Set your template cache to approx. 5x the total Mb of your CFML code pages e.g. if you have 5Mb of code then set it to 25Mb.

4. Restart both cfserver.exe and cfexec.exe daily

5. Reboot the box once a week

6. Deprecate the use of CFINSERT and CFUPDATE

7. Check that you don't have CFMAIL with an empty BODY attribute

8. Set the address of the mail server using IP address not DNS name.

Using the above we've gone from the same/similar scenario as yourselves, 100% CPU usage and having to reboot several times daily to clean server logs and 100% uptime for the past three weeks.

John

-----Original Message----- From: Steve Nelson [mailto:m@secretagents.com] Sent: 19 April 2001 20:46 To: Fusebox Subject: Re: OT: CFServer taking 100% processor

A few things:

1) make sure you're running cf 4.5 SP2 2) turn on Log Slow Pages, it's under Logging-Settings See if you can pinpoint which pages are taking too long that will help to figure out the problem. 3) How many hits are you getting? is it possible you've just maxed out the server? 4) Check your web server logs to see if you're being hacked. Look for a lot of requests with the same IP address. 5) Turn on logon/logoff auditing in NT. Then check your NT security events to see if you're being hacked. look for a lot of event ID 529. That means a bad password 6) Try lowering your simultaneous requests to the number of processors on the server. 7) Do you have automatic locking turned on? Turn it off.

Try those.

Steve

Brian Doyle wrote: > > Hiya folks, > We launched our fuseboxed site in January and have had essentially no > problems up until recently. Starting yesterday the CF server has hung at > 100% CPU time intermittently. We've tried a number of different ways to > figure it out but we're stumped, as is out network guy. We haven't added > anything in the past two days (other than a flash banner which we've since > deactivated). The logs aren't full. We're running it on a 2000 server with > SQL 7.0 as well (although SQL isn't freaking out). > > I know its one of those stab in the dark questions, but we can't figure out > what it could be. Any help would be greatly appreciated. > > Thanks! > > -Brian > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/fusebox@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists