Query on parallelism

• M&M

  SSC-Insane

  Points: 21700

  More actions

  April 15, 2010 at 12:45 pm

  #231690

  Would parallelism cause high CPU?

  If parallelism is causing more than 50% of wait time, should we go ahead and disable parallelism?

  In this case, the CPU usage is low around 5%, but wait time on parallelism is more than 50%

  Please share your thoughts

  M&M

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  April 16, 2010 at 9:34 am

  #1152948

  If you are considering a single query then try out using MAXDOP hint if that helps.

  MJ