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

• stephenhai

  Mr or Mrs. 500

  Points: 553

  More actions

  December 5, 2011 at 12:07 pm

  #247886

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

  I know this error ususally happens in SQL server 2000.

  Does anyone know that it also will happen in SQL server 2008 or it has been fixed in 2008

  Thanks

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  December 5, 2011 at 12:19 pm

  #1416968

  Still happens in SQL 2008..

  CEWII

• stephenhai

  Mr or Mrs. 500

  Points: 553

  More actions

  December 5, 2011 at 12:25 pm

  #1416976

  Thanks...

  Is it still using the same options Microsoft suggests

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  December 5, 2011 at 2:02 pm

  #1417026

  I think so.

  CEWII

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 5, 2011 at 2:08 pm

  #1417031

  Deja-vu... I've been working on these all day

  http://blogs.msdn.com/b/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  December 5, 2011 at 2:20 pm

  #1417038

  Thats funny, I have that exact same article hanging on the wall of my cubie, from when I used to get these all the time..

  CEWII