Red Gate forums :: View topic - Parallel execution against servers not databases
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

Parallel execution against servers not databases

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
spivey24



Joined: 17 Oct 2006
Posts: 18

PostPosted: Mon Nov 14, 2011 5:24 pm    Post subject: Parallel execution against servers not databases Reply with quote

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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Tue Nov 15, 2011 6:12 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group