How to increase parallel execution?

dmt · Joined: 02 Dec 2011 Posts: 2

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.

Chris Auckland · Posted: Tue Dec 06, 2011 6:47 pm Post subject:

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

dmt · Joined: 02 Dec 2011 Posts: 2

Thx Chris.

Why upper limit is 25 and when will the new version SQL Multi Script?

Chris Auckland · Posted: Wed Dec 07, 2011 1:52 pm Post subject:

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

	All times are GMT + 1 Hour
Page 1 of 1