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).
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:
Post Comments (Atom)
No comments:
Post a Comment