Other than an eventual timeout thrown by CF - are you getting any SQL errors when this situation arises? (from either cf trying to run a query or when trying to execute a query via analyzer) Do any errors show up in the SQL logs?
On Mon, May 16, 2011 at 12:37 PM, Charlie Stell <[email protected]>wrote: > An increase of the number of queries being executed via cfquery > where queryparam isn't being used - regardless of it being from a user > request or a scheduled process... > > > On Mon, May 16, 2011 at 12:13 PM, Scott Weikert <[email protected]>wrote: > >> >> No, no recent updates (that I'm aware of), no increase in traffic. >> >> When you say "request increase" are you talking about behind-the-scenes >> DB requests? Or an increase in usage by people with a corresponding >> increase in DB traffic? >> >> On 5/16/11 10:06 AM, Charlie Stell wrote: >> > 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. >> > >> > >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
