Hi, Thanks Charlie for all your help and information. I really appreciate what you do for the community. Like I said before, you are the first in my list. I would get in touch with you right away when the time comes. :-)
As for the setting, I guess you were referring to the * Disable global client variable updates * . In our case, we use lastvisit. So I dont think I can disable it. Or atleast for now. :-) Let me know if it is some other setting you were referring to. <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Mon, Jan 25, 2010 at 4:09 PM, Charlie Arehart <[email protected]>wrote: > Ajas, while you await Derrick’s reply, I’ll point out that the details > for how to purge database-driven CF client variable repositories is indeed > documented, but only in a technote: > > http://kb2.adobe.com/cps/185/tn_18514.html > > > As for FR helping you see the time being spent per request and that things > are spiking, it is indeed a great tool for that. Note as well that if you > enable the JDBC wrapping for the DSNs that are set to be client var repos, > you will also have in FR’s logs the details of every SQL statement and how > often thy are happening. If the problem is what I suspect, you will find > that there are requests to read and write to these DBs on EVERY request (at > least every request to an app that has clientmanagement enabled, again more > in the resources I pointed to), which could be devastating to performance > (I should add that SeeFusion and the CF 8/9 Server Monitor could also help > in different ways in identifying this information also.) > > Certainly if there is no index on the key columns in CData and/or CGlobals, > that could exacerbate the problem. You’re almost there. > > But even with the purging and improved indexing, you should still check > out the resources I shared: you may instead be able to resolve the root > cause for why there’s so much I/O to these client var repos in the first > place. It may not be because of client variable usage you intend. Also, for > any reading this, if you would go “phew, well we don’t use client > variables”, don’t be so quick to be relieved. Again, as I discuss in the > other resources, it could hurt you even if you never ever say cfset > client.somevar = someval. Again, too much to explain in email. See the > resources if you’re interested. > > /charlie > > > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Ajas > Mohammed > *Sent:* Monday, January 25, 2010 10:35 AM > > *To:* [email protected] > *Subject:* Re: [ACFUG Discuss] Ideal memory & Configuration for CF > Production server? > > > > Derrick, do you mind sharing the script or logic off the list? > > > I installed FusionReactor and here is what I have found so far. > > Some pages are taking 8-25 seconds. Found out that there are bad indexes. > > Here are the stats > Average Request Time (ms) 248 > Used Memory (KB) (12%) 62,903 > Allocated Memory (KB) 73,792 > Maximum memory (KB) 504,896 > Free memory (KB) 441,992 > > So looks like memory is not an issue. Then I checked CPU usage as well and > CPU also doesnt spike up meaning its the calls to database which is causing > issues so far. > > I will keep you all updated on this and my journey with FusionReactor. > > Thanks, > > <Ajas Mohammed /> > > > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- >
