Hi all
Sorry for the OT post, but I REALLY need some help on this one -
We've got a reasonably beefy Win2K server (dual P-III 500MHz, 640MB RAM)
which has CF 4.5.2 and SQL Server 7.0 on it. We've got all the latest
service packs, latest MDAC drivers, no unlocked writes to App variables, we
don't use session variables, we use query caching with a max of 200 cached
queries.
It's been running fine for two months, with no problems - managed to go
without a reboot for a whole six weeks - then last week, all of a sudden,
the SQL service started maxing out the CPU. I've had a similar situation
where I inherited some appallingly written old sites that were written
before I joined the company, with unlocked writes to app variables all over
the place. They killed the server almost every day, but the problem stopped
as soon as I fixed them, and in that case it was the CF service that maxed
out, NOT the SQL service. There's nothing on this server except new sites
with all app variables locked.
Now the puzzler is that nothing has changed on the machine in the last four
weeks. The highest number of simultaneous web users on it was 30, so it's
not being hammered hard or anything. We do run some pretty complex queries
and stored procedures, but I spent two days last week optimising everything,
and it's still dying.
This is the real killer - as soon as we stop the SQL service, the CPU usage
goes back to normal (10-20%), and the memory usage returns to about 200M.
But, as soon as we start the SQL service again, it goes right back up to
100% CPU within about 2 seconds. We limited SQL to just using the one CPU,
so we can just about keep the server alive, but only just.
I'm tearing my hair out over this - why would the machine suddenly start
dying when nothing has changed????
Anyone got any suggestions? Anyone? Please? HELP!!!!!!!!!!!!!!
Alistair Davidson
Senior Developer
Rocom New Media
www.rocomx.net
"There is no spoon"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
