> Unusual situation. We have been running ColdFusion Professional
> Server our
> on web servers (2000/IIS) and up until the last week or so we were fine.
> Our intranet site is query intensive with as many as 40 queries
> occurring on
> every hit. Typically, by the afternoon the ColdFusion Application Service
> is non-responsive and our CPU load is 100%. When you stop the ColdFusion
> Application Service, CPU load drops to 5-6%. However, within minutes it
> returns to 100%. Does anyone have any ideas on what is causing this?
>
> In addition, is there any performance upgrade when switching to ColdFusion
> Enterprise Server? (Or is it simply additional features?)
What database server?
Are you using CFTransaction?
If you're using CFTransaction, it might be deadlocking on some of the table
reads/writes as one might be waiting on another which is waiting on the
first (if you get what I mean)
We had that when using CFTransaction on insert/get new ID (one of the junior
programmers who didn't know SQL Server bits)
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
