How to increase parallel execution?

dmtdmt Posts: 3
edited December 7, 2011 7:52AM in SQL Multi Script
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.
· Share on Twitter

Comments

  • Chris AucklandChris Auckland Posts: 769
    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
    · Share on Twitter
  • dmtdmt Posts: 3
    Thx Chris.

    Why upper limit is 25 and when will the new version SQL Multi Script?
    · Share on Twitter
  • Chris AucklandChris Auckland Posts: 769
    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
    · Share on Twitter
Sign In or Register to comment.