but shouldnt cfmx handle it a bit more elegant? tw
On Thu, 04 Nov 2004 17:41:56 -0400, Don Chunshen Li <[EMAIL PROTECTED]> wrote: > 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:183432 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