Single-click script execution on multiple SQL Servers.
Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor
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 3:16 am
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.
Technical Support Engineer
- 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 0 guests