> 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).
You might try disabling connection pooling for that database (or if you can narrow it down, for a specific datasource you set up for just this one operation). That will probably prevent this problem, although you might pay a performance penalty. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm