You definitely need to separate SQL Server from CF - i.e. two boxes.
To find the biggest bang for your buck you need to look into the logs and
turn on debugging, performance monitor, etc to find where the bottle neck
is. Then there is caching....
Regards,
Dave Crosby.
----- Original Message -----
From: "Dave" <[EMAIL PROTECTED]>
To: "Spectra-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, 22 May, 2001 8:52 AM
Subject: Performance
> I am running a reasonably active site with CF4.5, Spectra 1.0.1 and
SQL Server 7 on a PIII 800 with 512M RAM. Amongst other ills, from time to
time response times plummet, or CPU usage goes to 100% (or both).
>
> I am considering adding RAM, moving SQL to its own box, upgrading to
Spectra 1.5. Does anyone have any feel (or even hard numbers) for which
approach is most critical, or gives me the biggest bang for the buck.
>
> Do I need to implement any or all of these, or is there a better solutions
which I haven't considered?
>
> Thanks for any input
> Dave
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
