How can we help you today? How can we help you today?

How to increase parallel execution?

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
0

Comments

3 comments

Sort by
  • Chris Auckland
    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 Auckland
    0
  • dmt
    Thx Chris.

    Why upper limit is 25 and when will the new version SQL Multi Script?
    dmt
    0
  • Chris Auckland
    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 Auckland
    0

Add comment

Please sign in to leave a comment.