Parallel execution against servers not databases
spivey24
Posts: 24
It would be very useful if there was another option for parallel execution:
Databases per Server to execute against simultaneously.
For example, we have about 180 databases across 6 database servers. Now ideally, I would want 3 scripts per server to be running at all times (for 18 total in parallel). This would give me the fastest possible execution and not overload each server.
We have kind of gotten around this by randomizing the distribution lists, but since scripts take different times to run on each server, it doesn't work that great.
Databases per Server to execute against simultaneously.
For example, we have about 180 databases across 6 database servers. Now ideally, I would want 3 scripts per server to be running at all times (for 18 total in parallel). This would give me the fastest possible execution and not overload each server.
We have kind of gotten around this by randomizing the distribution lists, but since scripts take different times to run on each server, it doesn't work that great.
Comments
I have passed it along to our development team so that when more work is done on the tool they can take it into consideration.