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:344541
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to