Wednesday, March 7, 2012

Intra-query parallelism causes deadlock

Has anyone seen the following message and if so how did you go about resolving the problem?

Server: Msg 8650, Level 13, State 1, Line 20
Intra-query parallelism caused your server command (process ID #15) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).Can anyone give me a low down on Intra-query parallelism and why a quad server will get this error?
Jim

Originally posted by Deddens
Has anyone seen the following message and if so how did you go about resolving the problem?

Server: Msg 8650, Level 13, State 1, Line 20
Intra-query parallelism caused your server command (process ID #15) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).

No comments:

Post a Comment