Red Gate forums :: View topic - How to increase parallel execution?
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

How to increase parallel execution?

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



Joined: 02 Dec 2011
Posts: 2

PostPosted: Mon Dec 05, 2011 2:01 pm    Post subject: How to increase parallel execution? Reply with quote

I need to simultaneously execute script on 32 db servers. Is it possible to increase the limit "Databases to execute against simultaneously"?

Thanks for answer.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Tue Dec 06, 2011 6:47 pm    Post subject: Reply with quote

I'm afraid not. It looks like the upper limit is 25.

There isn't any development planned for Multi-Script in the near future, so it's likely to stay like this for a while.

Sorry I can't be of more help.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
dmt



Joined: 02 Dec 2011
Posts: 2

PostPosted: Wed Dec 07, 2011 10:07 am    Post subject: Reply with quote

Thx Chris.

Why upper limit is 25 and when will the new version SQL Multi Script?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Wed Dec 07, 2011 1:52 pm    Post subject: Reply with quote

Thanks for your reply.

There isn't any plans for a new version of Multi-Script at this stage.

The reasoning behind having a 25 simultaneous database limit was because most users workstations will have between 1 and 4 cores and a finite network bandwidth. We thought it was safer to restrict the number of simultaneous executions rather then causing the machine to crash/run out of memory or use all the network bandwidth.

The 25 simultaneous connections still means there are 25 executed at once, so each time one finishes one of the remaining can start.

I hope this helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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