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