Have you recently upgraded versions of MS-SQL? And/or recently had a significant increase in requests?
In the system I was referring to, it had been running for 3 years without this being an issue - then we upgraded to SQL 2005 and had a request increase of about 25% - at this point we started having DB hangs about every other day. I don't know if it was the load increase or a change in execution plan handling by SQL... but the db hangs stopped as soon as we incorporated cfqueryparam. On Mon, May 16, 2011 at 11:53 AM, Scott Weikert <[email protected]> wrote: > > Yep, there's quite a few queries without cfqueryparam - but again, this > is behavior that has popped up of late - this is code that's been around > for years that hasn't had this sort of issue. So I don't know that this > is a problem. > > I'm unsure as to recovery model - we have a hosting guy who maintains > the DB box. > > On 5/16/11 9:50 AM, Charlie Stell wrote: > > Do you have many queries (especially queries ran very often) that do not > use > > cfqueryparam? Those symptoms remind me of system I worked in once where > most > > of the queries were not using queryparam or any other form of binding - > and > > as a result sql's query cache was filling up too often... though I'm sure > > many other things could be the culprit : ) > > > > What recovery model is your db using? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
