Ajas, Slow running pages are subjective. You have to consider two aspects when considering thresholds for slow running page logging.
What is slow to you as a developer? What is slow to the business? Typically, the developer will shoot low and the business will estimate high. You have to find a medium using these thresholds. You also have to choose your level of effort or your "battles". You have to create a priority scheme. Assuming you choose 10 seconds for your threshold, If you have a template that runs 45 seconds three times a week versus a template that is 25 seconds that runs 100+ times a week. You may want to choose the 25 second template. Now, add in complexity. How critical is a given template? How complex is it to possibly troubleshoot the interfaces that touch the template? So, what you will more than likely develop is a set of rules. Not just one blanket value for slow running pages will solve all of your slow running business processes. Any file I/O to the operating system does introduce some overhead when writing to the log. How often is the log being written to? When was the last time that you backed up your log files and purged them? Also, how will you figure out which templates are slow in production if you are not monitoring them for a certain period of time? 5-10 minutes is not an accurate snapshot of your business cycle, unless all of your business happens in that 5-10 minutes. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Sun, Feb 22, 2009 at 1:38 PM, Ajas Mohammed <ajash...@gmail.com> wrote: > 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 >>>> ------------------------------------------------------------- >>>> >>>> >>>> >>>> >>> >> >
