How to increase parallel execution?

Single-click script execution on multiple SQL Servers.

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

How to increase parallel execution?

Postby dmt » Mon Dec 05, 2011 2:01 pm

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.
dmt
 
Posts: 2
Joined: Fri Dec 02, 2011 11:43 am

Postby Chris Auckland » Tue Dec 06, 2011 6:47 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby dmt » Wed Dec 07, 2011 10:07 am

Thx Chris.

Why upper limit is 25 and when will the new version SQL Multi Script?
dmt
 
Posts: 2
Joined: Fri Dec 02, 2011 11:43 am

Postby Chris Auckland » Wed Dec 07, 2011 1:52 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 1 guest