Parallel execution against servers not databases

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Parallel execution against servers not databases

Postby spivey24 » Mon Nov 14, 2011 5: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.
spivey24
 
Posts: 18
Joined: Tue Oct 17, 2006 3:16 am

Postby chriskelly » Tue Nov 15, 2011 6: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.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 1 guest