Post reply

change max degree of parallelism

  • November 3, 2016 at 7:54 am

    #318616

    Dear all,

    I will need to change the max degree of parallelism from 2 to 6. Do I have to restart the SQL Server instance in order to take effect?

    thanks.

  • November 3, 2016 at 8:03 am

    #1910356

    No, you will just need to run the reconfigure statement.

  • November 3, 2016 at 8:18 am

    #1910364

    thank you

  • November 4, 2016 at 8:06 am

    #1910602

    Sorry. If I use the GUI instead of the sql, will it also automatically assume the change? Or do I have to restart it?

  • November 4, 2016 at 8:13 am

    #1910605

    You still won't need to restart SQL Server if you make the change through the GUI. If you are unsure what happens when you make changes using the GUI always script out the change so you can check what is happening.

  • November 4, 2016 at 8:40 am

    #1910611

    Thanks

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply