You are viewing limited content. For full access, please sign in.

Question

Question

Distributed Computing Cluster on SQL server?

Distributed Computing Cluster
Updated May 9, 2014
asked on May 9, 2014

We are preparing to import a large number of images (over 500,000) that need to be OCR'ed for a customer.  I am wondering if their Laserfiche SQL server which is only used for running SQL for Laserfiche could be used as part of a Distributed Computing Cluster?  We would schedule it to OCR on off hours when users are not in the system.  Is this an advisable approach?

 

Thanks,

Jen

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on May 9, 2014

As long as you're careful about turning the DCC jobs on and off I don't think it will be a problem. Before I enlist the production servers, I'd look at bringing the users' workstations into the cluster as well. With careful management of when they are available for DCC to use, we've been able to use regular workstations to do OCR at night. You'll get a lot more cores and have less risk to the server.

0 0
replied on May 9, 2014

As Devin says, there shouldn't be a problem. Just make sure that there are no tasks running during hours that you expect the SQL server to be accessed. To achieve scheduling of on and off states like this, you will want to use the Windows Task Scheduler and the DCC PowerShell modules. For more information on the DCC PowerShell modules, check out the Admin Guide.

0 0
replied on May 9, 2014

Great.  Thanks Devin and Matthew for your responses.

Jen

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...