It seems to be an interesting situation. I'm thinking loud here, in addition to backup, for performing other heavy duty db job as well, another option might be: 1) schedule the backup or other similar db job; 2) disable ALL web app services for the interval (done via server admin? global approach)
Maybe there's other better alternatives, I can't think at the moment. Don >anyone else out there have a situation >where you run a query against a ms sql server >database that might be in the middle of backing up >or some other job and the query times out, or just >doesnt respond and then the jrun just goes berzerk? > >berzerk = thread count through the roof, and eventual cfmx server not >responding to any requests? > >thanks! > >-- >tony > >Tony Weeg > >macromedia certified coldfusion mx developer >email: tonyweeg [at] gmail [dot] com >blog: http://www.revolutionwebdesign.com/blog/ >cool tool: http://www.antiwrap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183430 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
