Parallelism operator in query execution plan

• gana79950

  Old Hand

  Points: 371

  More actions

  September 16, 2019 at 9:30 pm

  #3680480

  Hi,

  I want to use option (MAXDOP 1) for a procedure to see if that improves the performance but there is no parallelism operator in query execution plan. So we cannot test with MAXDOP is this case right?

  Currently we have MAXDOP=4 at server level and using MAXDOP=1 at query level improved query performance where parallelism operator cost is high. I have another query taking time but it is not using parallelism operator so wondering how I can use MAXDOP here.

   

• SGT_squeequal

  SSCertifiable

  Points: 7167

  More actions

  September 17, 2019 at 6:32 am

  #3680565

  Before changing your maxdop read this https://support.microsoft.com/en-us/help/2806535/recommendations-and-guidelines-for-the-max-degree-of-parallelism-confi

   

  ***The first step is always the hardest *******