Ok I've got a headscratcher here, would love some input from some other brains out there. Sometimes it sucks to be the lone gunman developer. :(
Got CF8 running using MSSQL. Lately, every now and again (too often) the DB appears to hang, anywhere from a minute or so to several minutes. As best I can tell (from previous times when it's happened, and I was remoting our DB box at the time) the CPU isn't spiking during these hangs. It seems to just be connections from our webservers to the database that is affected. Based on comments from one of my employers working in the system at the time, and from a few clients, it seems these hangs are triggered by a specific action in our system - a content-save to a particular table, that holds the lion's share of client content (webpage content). I've tried making changes to said script a couple of times - adjusting the query, storedproc-ing it up. There seems to be no rhyme or reason to it - different times it hangs, there's different amounts of content being saved. One client tends to stuff the most in there - another, not nearly so much - and both seem to trigger the hang. This behavior is pretty recent - just the last few weeks. And I can't for the life of me puzzle out what's different. We had an issue recently with an old bug, the "corrupt table" issue, and there was a little bit of fiddling with the datasource settings before this issue was somewhat resolved, so I have to wonder if something adjusted during that episode isn't the cause of this behavior. Nothing in the datasource settings screams "ME ME ME I'M THE ONE". When the hangs occur, triggered by whatever use on our main webserver, it affects the DB connections on the other servers as well - even a web environment that is using other databases (dev env) but said other DBs are on the same DB server. All servers just sit on "waiting on..." in the browser status 'til the hang passes, then all is well again. I'm about at my wit's end trying to puzzle this one out - I sure could use some nudging in the right direction. Thanks in advance - --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
