Home Forums SQL Server 2014 Administration - SQL Server 2014 Max Degree of Parallelism - 24 Core processor 2 NUMA nodes RE: Max Degree of Parallelism - 24 Core processor 2 NUMA nodes

  • May 2, 2016 at 6:20 am

    #1875864

    info.sqldbamail (5/2/2016)

    cost threshold for parallelism is set to 5.

    The default value of 5 is very low, normally recommend starting with 50 and work from there.

    😎