SQL Server Performance

error while select query fired

Discussion in 'General Developer Questions' started by ranjitjain, Apr 13, 2005.

  1. ranjitjain New Member

    Hi experts,
    I've run a select query by joining three tables with left join and i'm getting this

    Intra-query parallelism caused your server command (process ID #55) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).

    what this error means, plz help me to understand what is it and what is hint option maxdop
  2. mmarovic Active Member

    You may consider looking at the explanation in BOL. Basically, there are bugs in execution of parallel execution plans. Setting Max Degree Of Parallelism to 1 you ask query to be performed by single CPU which means parallel execution plan will not be considered.

Share This Page