I know I'm repeating myself, but: did you turn off debugging and try again?
Also, a colleague of mine ran into "unfixable" memory problems on MX7 when he wrote an application that loaded an insane number of CFCs -- basically, he was looping over a gigantic query and creating a single CFC to represent each row. I say "unfixable" because the fix was to not do that anymore, i.e. change the code considerably. Are you loading a ton of CFCs into memory at any one time? Also, is it possible any of your apps are loading queries that are hundreds or thousands of rows? I know from experience that queries like this, run inside of a large loop, can bring CF down really fast. Honestly, my first suggestion ( if you can rule out the really obvious things like above ) would be to try hooking up a profiler to ColdFusion and see if anything jumps out at you. I was able to successfully get YourKit hooked up to MX6.1 without much trouble. I did have to remove the UseParallelGC jvm option from the jvm settings, but otherwise it worked fine. I'd hate to see you spin your wheels, stabbing in the dark at various fixes, without first seeing if a profiler can tell you what's going on inside your JVM. Good luck! Marc On Fri, May 23, 2008 at 6:59 AM, shalja <[EMAIL PROTECTED]> wrote: > > Hi Marc > > This sounds like a really good tip. I am in touch with my DB > Administrator and we are considering changing the drivers to jtds. > Thanks for your help.If you have any other suggestions please let me > know. > > Shalja > > On May 22, 7:11 pm, "Marc Esher" <[EMAIL PROTECTED]> wrote: >> I can personally tell you that microsoft's sql server drivers are >> definitely NOT safe to use! If you're going to try out drivers for sql >> server, definitely look into jtds. I've been using jtds in big >> production java apps for several years now with much success. >> >> I had a big memory leak in a java app a few years back. It'd get up to >> a gig then crash. So I stuck a profiler on the app and found that the >> sql server driver was retaining memory. >> >> I dropped jtds in as a replacement for the ms drivers. started the >> app, and bam, no more memory leaks. >> >> i even ran some production CF sites on jtds for a while but ran into a >> really weird recursion problem and had to revert. But that was quite >> possibly a code bug. >> >> marc >> >> On Thu, May 22, 2008 at 1:41 PM, Adam Haskell <[EMAIL PROTECTED]> wrote: >> > You may consider a JVM update MX7 should run on 5 just ok (you may even see >> > what happens on Java 6). Check out VisualVM >> > (https://visualvm.dev.java.net/) it works much better with Java 6 than >> > Java >> > 5 but it will give you a plethora of insight into what is going on. I need >> > to blog about VisualVM I just learned about it from folks that went to >> > JavaOne. >> >> > As for SQL server you may also check out Microsoft's JDBC drivers and see >> > how those preform, it seems like at one point some one at Figleaf was >> > saying >> > those were better than the packaged drivers, may at cfUnited 2 years ago... >> >> > Adam Haskell >> >> > On Thu, May 22, 2008 at 11:40 AM, Brian Kotek <[EMAIL PROTECTED]> wrote: >> >> >> You might try installing FusionReactor since it gives very detailed memory >> >> usage inforamation, among other things. >> >> >> Otherwise you'll have to troubleshoot it yourself, contact Adobe and >> >> purchase support, or contact a consultant that specializes in this sort of >> >> thing like Alagad. You might also try installing the app on a CFMX8 test >> >> server to see if that makes any difference. >> >> >> On Thu, May 22, 2008 at 10:23 AM, shalja <[EMAIL PROTECTED]> wrote: >> >> >>> Hi Brain >> >> >>> I have the following version installed: >> >> >>> 7,0,2 >> >> >>> We have installed all patches. >> >> >>> Thanks >> >> >>> Shalj >> >> >>> On May 22, 3:00 pm, "Brian Kotek" <[EMAIL PROTECTED]> wrote: >> >>> > What is the actual version number you're using? Have you applied all of >> >>> > the >> >>> > CFMX7 updaters and hotfixes? >> >> >>> > On Thu, May 22, 2008 at 9:21 AM, shalja <[EMAIL PROTECTED]> wrote: >> >> >>> > > Hi >> >> >>> > > I am using CF7 MX >> >> >>> > > Shalja >> >> >>> > > On May 22, 2:15 pm, "Brian Kotek" <[EMAIL PROTECTED]> wrote: >> >>> > > > Also remember that you can always get actual professional support >> >>> > > > from >> >>> > > Adobe >> >>> > > > directly. >> >> >>> > > > That said, you haven't said what version of CF you are on. It would >> >>> > > probably >> >>> > > > be worth upgrading to the latest version before you try anything >> >>> > > > else. >> >> >>> > > > On Thu, May 22, 2008 at 6:26 AM, shalja <[EMAIL PROTECTED]> >> >>> > > > wrote: >> >> >>> > > > > Hi Mark >> >> >>> > > > > Thanks for your quick response. I am using the following JVM >> >>> > > > > version: >> >> >>> > > > > 1.4.2_09-b05 >> >> >>> > > > > Thanks >> >> >>> > > > > Shalj >> >> >>> > > > > On May 22, 11:06 am, "Mark Mandel" <[EMAIL PROTECTED]> wrote: >> >>> > > > > > Shai, >> >> >>> > > > > > I have had a lot of success using JConsole, jmap and SAP's >> >>> > > > > > memory >> >>> > > > > analyzer >> >>> > > > > > to discover memory leaks and diagnose them. >> >> >>> > > > > > What JVM are you on? >> >> >>> > > > > > Mark >> >> >>> > > > > > On Thu, May 22, 2008 at 7:45 PM, shalja >> >>> > > > > > <[EMAIL PROTECTED]> >> >>> > > wrote: >> >> >>> > > > > > > Hi >> >> >>> > > > > > > We are experiencing memory leak problems on our web servers. >> >>> > > > > > > The >> >>> > > > > > > servers go down ever so often and we have to restart >> >>> > > > > > > Coldfusion in >> >>> > > > > > > order to restore service. >> >> >>> > > > > > > Are there any tools available which can help to monitor >> >>> > > > > > > exactly >> >>> > > which >> >>> > > > > > > CFC's are causing the heap to fill up and crash the system? >> >>> > > > > > > Also is >> >>> > > > > > > there any patch that can be applied to make the garbage >> >>> > > > > > > collection >> >>> > > > > > > more effective. >> >> >>> > > > > > > I was thinking of installing the following tools for >> >>> > > > > > > monitoring: >> >> >>> > > > > > > 1) >> >> >>> > > > > >http://commerce.bea.com/products/weblogicjrockit/jrockit_prod_fam.jsp >> >>> > > > > > > 2)http://www.borland.com/downloads/download_optimizeit.html >> >> >>> > > > > > > However, both the above tools are not available to download >> >>> > > anymore. >> >> >>> > > > > > > If anyone has managed to resolve this issue please help and >> >>> > > > > > > any >> >>> > > advise >> >>> > > > > > > on monitoring tools for heap would be much appreciated. >> >> >>> > > > > > > Thanks >> >> >>> > > > > > > Shal >> >> >>> > > > > > -- >> >>> > > > > > E: [EMAIL PROTECTED] >> >>> > > > > > W:www.compoundtheory.com > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
