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).
Showing posts with label resolving. Show all posts
Showing posts with label resolving. Show all posts
Wednesday, March 7, 2012
Intra-query parallelism causes deadlock
Labels:
20intra-query,
causes,
database,
deadlock,
following,
intra-query,
level,
line,
message,
microsoft,
msg,
mysql,
oracle,
parallelism,
problemserver,
resolving,
server,
sql,
state
Subscribe to:
Posts (Atom)