Thanks Teddy, I appreciate your input. That was very helpful and it makes lot of sense.
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. Good example. We are in second case. Some templates which are run every day and may take 5 secs to render, but imagine 1000's of users using same page and probably it adds up on the server and results in slow performance. How often is the log being written to? When was the last time that you > backed up your log files and purged them? > Dont beat me up people, but we dont have a policy yet. So, what are the logs you need to constantly monitor??? Any tips you want to provide as to what to look for and how often you need to monitor? 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. Very true. I thought 5-10 minutes because this will be first time I will monitor something, so I wanted to to start small. Then I could start monitoring more as I start understanding what is happening, why pages are running slow etc. FYI, just to clarify, no one has asked me to do all this, so please *do not think* that I am not doing my work. I have tons of development lined up but at the same time, I want everything we do, to be best and efficient, and since somebody has to stand up for it, I am the one who wants to go for it. I believe in best practices,efficiency, clean code etc and I am trying my best to make sure that our projects are developed based of these ideologies. Thanks again. <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, Feb 23, 2009 at 8:52 AM, Teddy R. Payne <[email protected]>wrote: > 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 - [email protected] > > > > On Sun, Feb 22, 2009 at 1:38 PM, Ajas Mohammed <[email protected]> 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 <[email protected]>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 - [email protected] >>> >>> >>> >>> On Tue, Feb 17, 2009 at 3:58 PM, Ajas Mohammed <[email protected]>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 <[email protected]>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 >>>>> [email protected] >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> 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:* [email protected] [mailto:[email protected]] *On Behalf Of *Ajas >>>>>> Mohammed >>>>>> *Sent:* Tuesday, February 17, 2009 2:00 PM >>>>>> *To:* [email protected] >>>>>> *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 >>>>> ------------------------------------------------------------- >>>>> >>>>> >>>>> >>>>> >>>> >>> >> >
