It will run happily on IIS and 2003. There are many things you can do to improve performance. I always start at the configuration level and work back to the code - unless I "know" there is something in the code that is causing the problem. Start with:
Server stuff - ram, processor, unecessary services, network card and card configuration etc. CF Ap Server stuff - settings in the CF Admin, jrun.xml and jvm.config files - Tuning the JVM can be especially helpful with an error like this. IIS Stuff - try separate application pools or web gardens. Now I'd look at the code. As a rule - all of the stuff above should be handled on the installation of a new production server. It's amazing to me how many production servers are tooling along using the default installation parameters. Remember, default installation of windows, iis, Coldfusion and the like is designed to cover the maximum number of installation scenarios - not to be the optimal configuration :) -Mark -----Original Message----- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 8:17 AM To: CF-Talk Subject: RE : Jrunsvc 100% cpu process I've a lot of long requests, but I never use select * FROM .. I'm using for example, SELECT cp.mycolumn, cv.lastname FROM c_particule cp, c_vector cv WHERE cp.id_c_table1 = cv.id_c_table2 Sometimes with a UNION command not more ... Do you think I need make something else ? I've read maybe jrunsvc donÂt like IIS 6.0 on windows server 2003 ?? -----Message d'origine----- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] EnvoyÉ : mardi 21 juin 2005 15:04 : CF-Talk Objet : RE: Jrunsvc 100% cpu process Long running SQL is no doubt the cause which is backing up requests. Do you have any long running requests? Reports, select * from large tables... ? -----Original Message----- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 13:36 To: CF-Talk Subject: Jrunsvc 100% cpu process Hello everybody, I've a real big problem on my server side. In fact I've Coldfusion 6.1 Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, width mysql 4.1. Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the connector to the last updates, I've try to use JRUN updater 5, and a lot of other things, but nothing work good. On my server side I've more than 10 web entries, for multiple clients. I can't find any explaination about this problem, someone have an idea please ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:210088 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54