SQL Server takes something like 85 - 90% of all available resources as soon
as it starts. In my experience moving SQL to a different machine has the
biggest effect on server performance. Spectra is also killing the machine .
.. . oops did I say that.
Thank You,
Jon Cole ACP
DevTech Inc.
[EMAIL PROTECTED]
206.956.0888
Learn more about DevTech @ www.Dev-Tech.com
"I hate to advocate drugs, alcohol, violence, or insanity to anyone, but
they've always worked for me."
- Dr. Hunter S. Thompson
-----Original Message-----
From: Dave [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 1:53 PM
To: Spectra-Talk
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.
