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 >> >> 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 > > 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 > ------------------------------------------------------------- > > > >
