Query on parallelism

  • 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

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

    MJ

Viewing 2 posts - 1 through 1 (of 1 total)

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