Post reply

max degree of parallelism / statistics

  • April 16, 2014 at 8:50 am

    #284666

    Hi Everyone,

    I have been reviewing at a nightly SQL Server optimisation Job we have running on our Navision/DynamicsNav database. My understanding of Microsoft best practice is that older editions of Navision should be run with a max degree of parallelism of 1.

    However the maintenance job …

    First sets the max degree of parallelism to 0

    Rebuilds the database statistics and indexes

    Returns the max degree of parallelism to 1

    Does it seem correct that the statistics are regenerated with a different degree of a parallelism that is different to what is actually used in production or will it not matter?

    Many thanks for any guidance

    David

  • April 16, 2014 at 12:52 pm

    #1706557

    Statistics have no dependency on parallelism or lack thereof.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 17, 2014 at 4:35 am

    #1706695

    Thanks Gail for your confirmation. Have a great weekend

  • November 17, 2014 at 8:44 pm

    #1759141

    Hi Gail

    I also face the same problem and confusion, MDP was 2 before on OLTP enviroment ,now want to adjust it, if there is a best practice to setup max degree of parallelism with 50% CPUs ? thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

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