A client had something similar a while back. It turned out that transaction
locks were not
being closed. You might check the locks under current activity.
At 12:27 PM 4/8/2001, you wrote:
>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
