Parallel execution against servers not databases

Single-click script execution on multiple SQL Servers.

Parallel execution against servers not databases

Postby spivey24 » Mon Nov 14, 2011 4:24 pm

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.
Posts: 18
Joined: Tue Oct 17, 2006 2:16 am

Postby chriskelly » Tue Nov 15, 2011 5:12 pm

Thank you for your suggestion.

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.
Posts: 373
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Return to SQL Multi Script 1

Who is online

Users browsing this forum: maxiwheat and 0 guests