Well, the driver failed in terms of JRUN. (ie JRUN Connection Error) One thing of note:
"...We have a DSN setup to a standard SQL DB... If we check "Maintain Connection" via DSN/ADVANCED the SQL CPU goes to 100%.. yet if we uncheck it, SQL goes to a stable 0-10% cpu but JRUN climbs to 50% CPU? any ideas? At first we thought it was a rogue query but the queries aren't consistent in that its not isolated to a specific query.." On 5/4/05, Tim McAuliffe <[EMAIL PROTECTED]> wrote: > Hi Scott, > > Yep, this is a bug. I had the same problem a while back in a gig at > Australand. Looks like you've found the right KB article too. We used the > updated drivers as instructed and it fixed the problem. > > HTH > > Tim > > > We are having some issues here at work with our CFMX 6.1 --> SQL > > connections, in that it seems to constantly spike in terms of CPU (RAM > > itself doesn't seem to move as much). > > > > At first we thought it was a rogue query, but closer inspection there > > is no consistent pattern (ie we scoped out Enterpise Manager and took > > a snapshot of what queries are being fired off). > > > > It's as if Coldfusion MX requests a query to be initiated to SQL > > Server, SQL Server proceeds to carry out that instruction but can't > > hand it back to Coldfusion server, and simply places itself in a > > holding pattern until coldfusion can accept it.. ie loss of connection > > or something along those lines. > > > > It strongly hints at: > > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=3Dtn_18807 > > > > Now the thing that has changed since we last looked at it, was that we > > dropped a NT DOMAIN from our network? can anyone explain or know of > > what causes the > > > > 52851 - 100% CPU utilization when SQL server unexpectedly closes a connecti= > > on. > > > > Bug? > > > > > > --=20 > > Regards, > > Scott Barnes > > http://www.mossyblog.com > > http://www.flexcoder.com (Coming Soon) > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > -- Regards, Scott Barnes http://www.mossyblog.com http://www.flexcoder.com (Coming Soon) --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
