DA scheduled searches best practices
EV/DA 904. SQL 2008.
We have a separate Discovery Accelerator instance for our internal General Counsel group. They have nearly 100 open DA cases in their Litigation instance. The paralegals insist on running DAILY scheduled searches on each one of these cases. Needless to say, this much processing cripples their DA instance. All of these scheduled searches will stall and not move. Immediate searches can be issued but they, too, sit their with zero progress. I have created three different windows of time that they can assign their scheduled searches to, but this does not seem to help.
Where do I start? Is thing going to be a combination of modifying the way they perform their searches, in addition to perhaps thinking of a second (or third) Discovery Accelerator instance? IMHO, daily scheduled searches is excessive, but I'm just the technology nerd. :)
I appreciate any insight!