Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Stuck tracking down CXPACKET issue RE: Stuck tracking down CXPACKET issue

  • November 5, 2013 at 7:54 am

    #1664150

    Currently our Cost of THreshold for Parallelism is 5 and the Max Degree of Parallelism is 0.

    We have 24 cores.

    Does that change your suggestion any?