What are the challenges you face when working across database platforms? Take the survey

Parallel execution against servers not databases

spivey24spivey24 Posts: 24
edited November 15, 2011 12:12PM in SQL Multi Script
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.


Sign In or Register to comment.