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 -~----------~----~----~----~------~----~------~--~---
