Intra-query parallelism causes deadlock

Deddens · #1 (**permalink**) 12-04-02, 11:04

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).

JDionne · #2 (**permalink**) 12-04-02, 11:07

Can anyone give me a low down on Intra-query parallelism and why a quad server will get this error?
Jim

Quote:

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).

Internet Services

Web Development

Digital Marketing

Consumer Tech