Hi, Teddy, I found the setting you mentioned to track slow running pages. If you go to Administrator, Debugging & Logging, the third option is Logging Settings. The first checkbox option provides the option to record slow running pages, which gets logged in server.log file. The initial setting is 30 seconds. I am thinking of making this 10. Any suggestions?
Also, lets say I enable this logging on production server for 5-15 minutes during work hours, is it going to be an issue or CF is smart enough to write log file and people wouldn't notice the slowness? Let me know. Thanks, <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 Tue, Feb 17, 2009 at 4:05 PM, Teddy R. Payne <teddyrpa...@gmail.com>wrote: > Ajas, > I would equate a QA server to a staging environment. The reason that I ask > this is not ncessary to load test, but it may be a safer location to run > your server monitoring tools to see if the same issues are present. > > As people have suggested various items that could cause prblems for > performance, you really just need to take a moment and look at your code to > evaluate what parts of your code are external to CF. Database calls, > webservice calls, imported API(s) or just about anything that would > interface with your application are all subject to scrutiny for performance > troubleshooting. How you consume external resources and process them > internally can cause unidentified issues. > > Teddy R. Payne, ACCFD > Google Talk - teddyrpa...@gmail.com > > > > On Tue, Feb 17, 2009 at 3:58 PM, Ajas Mohammed <ajash...@gmail.com> wrote: > >> Thanks again everyone. >> >> Teddy, we have staging which we call QA (Quality Assurance) and this is >> not hosted on third party hosting service. Its here in our local network and >> we allow clients to test functionality or new stuff on this QA setup. Dont >> know if this could be an issue because typically you would expect staging to >> be exact replica of production in terms of machine, setup etc. We have exact >> setup, but processing power and number of hits etc are definitely different. >> >> So let me ask this, do you need to have staging setup locally or remotely >> because in my case, we have main application on third party hosting site. >> >> John, Yeah I agree at SQL stuff you mentioned. We are looking at that >> also. But as you mentioned, there are things which needs to be changed in CF >> code like unnecessary calls to a table or not filtering results etc. >> >> The other thing is all these applications we have use client variables >> stored in database. All login etc is done by client variables. >> >> >> <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 Tue, Feb 17, 2009 at 3:24 PM, John Mason <ma...@fusionlink.com>wrote: >> >>> Charlie's 411 page has the complete list of these tools. SeeFusion and >>> Fusion Reactor really help in this stuff. If the apps have been running fine >>> to some time, one of the most common things I see these days is the growth >>> and mis-management of datasources. As records keep building up in the >>> database, you have to really consider the impact of some of your code but >>> also the data it's pulling. For example, doing a "select *" on a table with >>> 1000 records doesn't take anything. Do a "select *" on a table with several >>> years of data going into millions of records could cause some serious >>> problems. Certain sql operations will place a lock on a table which could be >>> expensive and slow down the entire app. Or improper or poor table column >>> indexing could result in full table scans with your innocent looking sql >>> calls. The point here is that in many cases CF code can be optimized but >>> it's a good idea to take a close hard look at what the datasource is doing >>> internally, specially with applications that have been running for several >>> years. >>> >>> SQL Server Management studio has a Data Execution plan toggle that you >>> can use to see the process Sql Serve uses to execute a sql call. Typically, >>> You want to avoid things like full table scans or expensive table locks that >>> make everything run a lot slower. There's plenty of blogs, books and >>> articles talking about SQL Server optimization. >>> >>> John >>> ma...@fusionlink.com >>> >>> >>> >>> >>> >>> >>> Ramirez, Ruben - Curtis 1000 wrote: >>> >>>> SeeFusion has been an invaluable tool for us. I initially heard about >>>> this from John Mason at one of his talks. >>>> http://www.seefusion.com/ >>>> Ruben >>>> >>>> ------------------------------------------------------------------------ >>>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Ajas >>>> Mohammed >>>> *Sent:* Tuesday, February 17, 2009 2:00 PM >>>> *To:* discussion@acfug.org >>>> *Subject:* [ACFUG Discuss] CF Applications hosted on third party >>>> webserver/hosting services >>>> >>>> Hi, >>>> >>>> Before I go to google and search for *performance optimization* & >>>> *monitoring* CF Applications, and how to check what parts are killing the >>>> application, I thought I would ask here first. >>>> >>>> We have application which is doing well supporting lot of clients. We >>>> are CF 7, IIS, Windows Server 2003 shop. >>>> >>>> We have about 6 - 8 applications, all same code base, hosted on third >>>> party hosting services. I can access CF Admin etc. >>>> >>>> As the transactions are growing, we have noticed that its getting slower >>>> and slower. >>>> >>>> So any inputs as to how to track >>>> >>>> 1. what part of cf code is running slow >>>> 2. any tools (if open source that would be nice) . I remember CF also >>>> has something, but never had chance to look at it. >>>> 3. most importantly, how do i get started monitoring load etc on the CF >>>> Server. >>>> >>>> Thanks for your patience and apologies, if I have missed any information >>>> that you need to answer my questions. >>>> >>>> FYI, I wanted to do this long time back, but could not because of work >>>> deadlines but looks like I have to find time to sort this critical issue >>>> ASAP. >>>> >>>> >>>> <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. >>>> >>>> ------------------------------------------------------------- >>>> To unsubscribe from this list, manage your profile @ >>>> http://www.acfug.org?fa=login.edituserform<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> >>>> ------------------------------------------------------------- >>>> >>> >>> >>> >>> ------------------------------------------------------------- >>> To unsubscribe from this list, manage your profile @ >>> http://www.acfug.org?fa=login.edituserform<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 http://www.fusionlink.com >>> ------------------------------------------------------------- >>> >>> >>> >>> >> >