If you're using MS SQL, you could have bad drivers. Get the latest ones (3.4) from the hotfixes page.
-nathan strutz Jean-Michel DE FILIPPI wrote: > 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 dont 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:210119 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
