Intra-Query Parallelism

• sbauer

  SSCommitted

  Points: 1966

  More actions

  June 23, 2006 at 12:02 pm

  #113552

  I had a developer come to me with the following error message

  query -

  select vw_feed_search.* from vw_feed_search Where vw_feed_search.fedd_status_id = 3 AND vw_feed_search.date_in between '2/16/2006' and '6/24/2006' ORDER BY vw_feed_search.date_in asc

  Error

  Intra-query parallelism caused your server command (process ID #%d) to deadlock.

  Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).

   

  I found article 837983 which describes the problem and give you a couple of different methods for work around.

  It mentions that you can modify the 'max degree of parallelism' to 1 via SP_Configure.

  I went a head and did that and the query now works, but I'm worried about the adverse affects if I do this in produciton.

   

  Any help would be greatly appreciated.

  Thanks

  Susan

   

• R2ro

  Default port

  Points: 1439

  More actions

  June 23, 2006 at 12:08 pm

  #645646

  Hi Susan,

  Look for the OPTION clause in the SELECT statement in Books Online.  You can specify the MAXDOP in the query instead of server-wide.

   

  HTH,

  Art