Optimal number of MS Access processes for Dual Xeon

[Syringer]

We have a computer that runs ~200 MS Access Databases every night (each of our clients has one) that basically imports a file and exports multiple ones. The import are basically .txt files that have 1k - 100k rows.

Each one can take anywhere from 5 seconds to 10 minutes to run on our Dual Xeon E5520 which has 8 cores total, 32GB RAM and an SSD RAID 0 set up.

The Access DB's run through a program called Automize which we can tell how many DB's we want to run at a time.

Is there an optimal # of DB's to run at a time then? Would it be 8, 16, 32 or is there any way to determine this?

 

[dealcorn]

If you tell Automize to increase (or decrease) the number of simultaneous databases it runs by one, do you have any metric to say whether productivity goes up or down? Because the client work load likely varies day to day, do not read too much into a single data point. If one is good, is two better?