Hi,
I am running a select query , which used left join on 5 tables. this is
reporting server there are no data updates, only select stmts. it has been
failing at runtime , the same query is running fine with different
parameters.
It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
degree of parallelism is 0 (before i change) , when i set max degree of
parallelism to 1 , then the query did run fine. As I remeber i havent
changed any configuration recently.
The query failed with following message.
Server: Msg 8650, Level 13, State 127, Line 1
Intra-query parallelism caused your server command (process ID #63) to
deadlock. Rerun the query without intra-query parallelism by using the query
hint option (maxdop 1).
Can somebody explain what caused it.
Thanks,
Subbu.
Hi!
Do please check the article at http://support.microsoft.com/?kbid=837983.
You will find possible reasons & workarounds there.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
> Hi,
> I am running a select query , which used left join on 5 tables. this is
> reporting server there are no data updates, only select stmts. it has been
> failing at runtime , the same query is running fine with different
> parameters.
> It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
> degree of parallelism is 0 (before i change) , when i set max degree of
> parallelism to 1 , then the query did run fine. As I remeber i havent
> changed any configuration recently.
>
> The query failed with following message.
> Server: Msg 8650, Level 13, State 127, Line 1
> Intra-query parallelism caused your server command (process ID #63) to
> deadlock. Rerun the query without intra-query parallelism by using the
query
> hint option (maxdop 1).
>
> Can somebody explain what caused it.
> Thanks,
> Subbu.
>
>
|||Thank you. I found it later.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:OUAafLChEHA.2916@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hi!
> Do please check the article at http://support.microsoft.com/?kbid=837983.
> You will find possible reasons & workarounds there.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
> news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
been
> query
>
Showing posts with label caused. Show all posts
Showing posts with label caused. Show all posts
Wednesday, March 7, 2012
Intra-query parallelism caused deadlock
Hi,
I am running a select query , which used left join on 5 tables. this is
reporting server there are no data updates, only select stmts. it has been
failing at runtime , the same query is running fine with different
parameters.
It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
degree of parallelism is 0 (before i change) , when i set max degree of
parallelism to 1 , then the query did run fine. As I remeber i havent
changed any configuration recently.
The query failed with following message.
Server: Msg 8650, Level 13, State 127, Line 1
Intra-query parallelism caused your server command (process ID #63) to
deadlock. Rerun the query without intra-query parallelism by using the query
hint option (maxdop 1).
Can somebody explain what caused it.
Thanks,
Subbu.Hi!
Do please check the article at http://support.microsoft.com/?kbid=837983.
You will find possible reasons & workarounds there.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
> Hi,
> I am running a select query , which used left join on 5 tables. this is
> reporting server there are no data updates, only select stmts. it has been
> failing at runtime , the same query is running fine with different
> parameters.
> It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
> degree of parallelism is 0 (before i change) , when i set max degree of
> parallelism to 1 , then the query did run fine. As I remeber i havent
> changed any configuration recently.
>
> The query failed with following message.
> Server: Msg 8650, Level 13, State 127, Line 1
> Intra-query parallelism caused your server command (process ID #63) to
> deadlock. Rerun the query without intra-query parallelism by using the
query
> hint option (maxdop 1).
>
> Can somebody explain what caused it.
> Thanks,
> Subbu.
>
>|||Thank you. I found it later.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OUAafLChEHA.2916@.TK2MSFTNGP12.phx.gbl...
> Hi!
> Do please check the article at http://support.microsoft.com/?kbid=837983.
> You will find possible reasons & workarounds there.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
> news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
been[vbcol=seagreen]
> query
>
I am running a select query , which used left join on 5 tables. this is
reporting server there are no data updates, only select stmts. it has been
failing at runtime , the same query is running fine with different
parameters.
It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
degree of parallelism is 0 (before i change) , when i set max degree of
parallelism to 1 , then the query did run fine. As I remeber i havent
changed any configuration recently.
The query failed with following message.
Server: Msg 8650, Level 13, State 127, Line 1
Intra-query parallelism caused your server command (process ID #63) to
deadlock. Rerun the query without intra-query parallelism by using the query
hint option (maxdop 1).
Can somebody explain what caused it.
Thanks,
Subbu.Hi!
Do please check the article at http://support.microsoft.com/?kbid=837983.
You will find possible reasons & workarounds there.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
> Hi,
> I am running a select query , which used left join on 5 tables. this is
> reporting server there are no data updates, only select stmts. it has been
> failing at runtime , the same query is running fine with different
> parameters.
> It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
> degree of parallelism is 0 (before i change) , when i set max degree of
> parallelism to 1 , then the query did run fine. As I remeber i havent
> changed any configuration recently.
>
> The query failed with following message.
> Server: Msg 8650, Level 13, State 127, Line 1
> Intra-query parallelism caused your server command (process ID #63) to
> deadlock. Rerun the query without intra-query parallelism by using the
query
> hint option (maxdop 1).
>
> Can somebody explain what caused it.
> Thanks,
> Subbu.
>
>|||Thank you. I found it later.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OUAafLChEHA.2916@.TK2MSFTNGP12.phx.gbl...
> Hi!
> Do please check the article at http://support.microsoft.com/?kbid=837983.
> You will find possible reasons & workarounds there.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
> news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
been[vbcol=seagreen]
> query
>
Intra-query parallelism caused deadlock
Hi,
I am running a select query , which used left join on 5 tables. this is
reporting server there are no data updates, only select stmts. it has been
failing at runtime , the same query is running fine with different
parameters.
It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
degree of parallelism is 0 (before i change) , when i set max degree of
parallelism to 1 , then the query did run fine. As I remeber i havent
changed any configuration recently.
The query failed with following message.
Server: Msg 8650, Level 13, State 127, Line 1
Intra-query parallelism caused your server command (process ID #63) to
deadlock. Rerun the query without intra-query parallelism by using the query
hint option (maxdop 1).
Can somebody explain what caused it.
Thanks,
Subbu.Hi!
Do please check the article at http://support.microsoft.com/?kbid=837983.
You will find possible reasons & workarounds there.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
> Hi,
> I am running a select query , which used left join on 5 tables. this is
> reporting server there are no data updates, only select stmts. it has been
> failing at runtime , the same query is running fine with different
> parameters.
> It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
> degree of parallelism is 0 (before i change) , when i set max degree of
> parallelism to 1 , then the query did run fine. As I remeber i havent
> changed any configuration recently.
>
> The query failed with following message.
> Server: Msg 8650, Level 13, State 127, Line 1
> Intra-query parallelism caused your server command (process ID #63) to
> deadlock. Rerun the query without intra-query parallelism by using the
query
> hint option (maxdop 1).
>
> Can somebody explain what caused it.
> Thanks,
> Subbu.
>
>|||Thank you. I found it later.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OUAafLChEHA.2916@.TK2MSFTNGP12.phx.gbl...
> Hi!
> Do please check the article at http://support.microsoft.com/?kbid=837983.
> You will find possible reasons & workarounds there.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
> news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I am running a select query , which used left join on 5 tables. this is
> > reporting server there are no data updates, only select stmts. it has
been
> > failing at runtime , the same query is running fine with different
> > parameters.
> >
> > It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
> > degree of parallelism is 0 (before i change) , when i set max degree of
> > parallelism to 1 , then the query did run fine. As I remeber i havent
> > changed any configuration recently.
> >
> >
> >
> > The query failed with following message.
> >
> > Server: Msg 8650, Level 13, State 127, Line 1
> >
> > Intra-query parallelism caused your server command (process ID #63) to
> > deadlock. Rerun the query without intra-query parallelism by using the
> query
> > hint option (maxdop 1).
> >
> >
> >
> > Can somebody explain what caused it.
> >
> > Thanks,
> >
> > Subbu.
> >
> >
> >
> >
>
I am running a select query , which used left join on 5 tables. this is
reporting server there are no data updates, only select stmts. it has been
failing at runtime , the same query is running fine with different
parameters.
It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
degree of parallelism is 0 (before i change) , when i set max degree of
parallelism to 1 , then the query did run fine. As I remeber i havent
changed any configuration recently.
The query failed with following message.
Server: Msg 8650, Level 13, State 127, Line 1
Intra-query parallelism caused your server command (process ID #63) to
deadlock. Rerun the query without intra-query parallelism by using the query
hint option (maxdop 1).
Can somebody explain what caused it.
Thanks,
Subbu.Hi!
Do please check the article at http://support.microsoft.com/?kbid=837983.
You will find possible reasons & workarounds there.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
> Hi,
> I am running a select query , which used left join on 5 tables. this is
> reporting server there are no data updates, only select stmts. it has been
> failing at runtime , the same query is running fine with different
> parameters.
> It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
> degree of parallelism is 0 (before i change) , when i set max degree of
> parallelism to 1 , then the query did run fine. As I remeber i havent
> changed any configuration recently.
>
> The query failed with following message.
> Server: Msg 8650, Level 13, State 127, Line 1
> Intra-query parallelism caused your server command (process ID #63) to
> deadlock. Rerun the query without intra-query parallelism by using the
query
> hint option (maxdop 1).
>
> Can somebody explain what caused it.
> Thanks,
> Subbu.
>
>|||Thank you. I found it later.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OUAafLChEHA.2916@.TK2MSFTNGP12.phx.gbl...
> Hi!
> Do please check the article at http://support.microsoft.com/?kbid=837983.
> You will find possible reasons & workarounds there.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Subbaiahd" <subbaiahd@.hotmail.com> wrote in message
> news:ewpo438gEHA.3264@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I am running a select query , which used left join on 5 tables. this is
> > reporting server there are no data updates, only select stmts. it has
been
> > failing at runtime , the same query is running fine with different
> > parameters.
> >
> > It is Dell machine with 4cpu/6gig /sql ent 2000/windows 2000 adv. max
> > degree of parallelism is 0 (before i change) , when i set max degree of
> > parallelism to 1 , then the query did run fine. As I remeber i havent
> > changed any configuration recently.
> >
> >
> >
> > The query failed with following message.
> >
> > Server: Msg 8650, Level 13, State 127, Line 1
> >
> > Intra-query parallelism caused your server command (process ID #63) to
> > deadlock. Rerun the query without intra-query parallelism by using the
> query
> > hint option (maxdop 1).
> >
> >
> >
> > Can somebody explain what caused it.
> >
> > Thanks,
> >
> > Subbu.
> >
> >
> >
> >
>
intra-query parallelism
Hi,
I am running sql 7 with sp3.
I got an error in running a sp.
The error message says, :Intra-query parallelism caused your server
command(process ID# 30) to deadlock. Rerun the query without intra-query
parallelism by using the query hint option (Maxdop 1).
Any ideas for this.
Thanks,
Can you upgrade to Service Pack 4 and see if that remedies the issue?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:OpMRxD35EHA.828@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am running sql 7 with sp3.
> I got an error in running a sp.
> The error message says, :Intra-query parallelism caused your server
> command(process ID# 30) to deadlock. Rerun the query without intra-query
> parallelism by using the query hint option (Maxdop 1).
> Any ideas for this.
> Thanks,
>
|||I do have sp4 installed
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:eXWhKH35EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Can you upgrade to Service Pack 4 and see if that remedies the issue?
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:OpMRxD35EHA.828@.TK2MSFTNGP14.phx.gbl...
>
|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:%23zvTGa35EHA.3756@.TK2MSFTNGP14.phx.gbl...
> I do have sp4 installed
Okay, your original post said SP3...
Did you try the MAXDOP hint? If it doesn't decrease performance
significantly, go with that. Otherwise, you're going to have to call PSS.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||What I did was increase the value for intra-query-Paralellism.
Is that ok instead of trying try the MAXDOP hint?
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#H3rPc35EHA.4004@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:%23zvTGa35EHA.3756@.TK2MSFTNGP14.phx.gbl...
>
> Okay, your original post said SP3...
> Did you try the MAXDOP hint? If it doesn't decrease performance
> significantly, go with that. Otherwise, you're going to have to call PSS.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:uqE72i35EHA.2316@.TK2MSFTNGP15.phx.gbl...
> What I did was increase the value for intra-query-Paralellism.
> Is that ok instead of trying try the MAXDOP hint?
Well, that will affect your entire server. If you're okay with that then I
guess it's not a problem, but it could have performance implications on
other queries that aren't having issues with parallelism. The MAXDOP hint
would only affect the one query.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||Thanks,
How do I do for The MAXDOP hint
>that would only affect the one query.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#DluLl35EHA.1632@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:uqE72i35EHA.2316@.TK2MSFTNGP15.phx.gbl...
>
> Well, that will affect your entire server. If you're okay with that then
I
> guess it's not a problem, but it could have performance implications on
> other queries that aren't having issues with parallelism. The MAXDOP hint
> would only affect the one query.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:%23lNE$r35EHA.824@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Thanks,
> How do I do for The MAXDOP hint
SELECT ...
FROM ...
WHERE ...
OPTION (MAXDOP 1)
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||Thanks,
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#zTbWH45EHA.3644@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:%23lNE$r35EHA.824@.TK2MSFTNGP11.phx.gbl...
>
> SELECT ...
> FROM ...
> WHERE ...
> OPTION (MAXDOP 1)
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
>
I am running sql 7 with sp3.
I got an error in running a sp.
The error message says, :Intra-query parallelism caused your server
command(process ID# 30) to deadlock. Rerun the query without intra-query
parallelism by using the query hint option (Maxdop 1).
Any ideas for this.
Thanks,
Can you upgrade to Service Pack 4 and see if that remedies the issue?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:OpMRxD35EHA.828@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am running sql 7 with sp3.
> I got an error in running a sp.
> The error message says, :Intra-query parallelism caused your server
> command(process ID# 30) to deadlock. Rerun the query without intra-query
> parallelism by using the query hint option (Maxdop 1).
> Any ideas for this.
> Thanks,
>
|||I do have sp4 installed
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:eXWhKH35EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Can you upgrade to Service Pack 4 and see if that remedies the issue?
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:OpMRxD35EHA.828@.TK2MSFTNGP14.phx.gbl...
>
|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:%23zvTGa35EHA.3756@.TK2MSFTNGP14.phx.gbl...
> I do have sp4 installed
Okay, your original post said SP3...
Did you try the MAXDOP hint? If it doesn't decrease performance
significantly, go with that. Otherwise, you're going to have to call PSS.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||What I did was increase the value for intra-query-Paralellism.
Is that ok instead of trying try the MAXDOP hint?
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#H3rPc35EHA.4004@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:%23zvTGa35EHA.3756@.TK2MSFTNGP14.phx.gbl...
>
> Okay, your original post said SP3...
> Did you try the MAXDOP hint? If it doesn't decrease performance
> significantly, go with that. Otherwise, you're going to have to call PSS.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:uqE72i35EHA.2316@.TK2MSFTNGP15.phx.gbl...
> What I did was increase the value for intra-query-Paralellism.
> Is that ok instead of trying try the MAXDOP hint?
Well, that will affect your entire server. If you're okay with that then I
guess it's not a problem, but it could have performance implications on
other queries that aren't having issues with parallelism. The MAXDOP hint
would only affect the one query.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||Thanks,
How do I do for The MAXDOP hint
>that would only affect the one query.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#DluLl35EHA.1632@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:uqE72i35EHA.2316@.TK2MSFTNGP15.phx.gbl...
>
> Well, that will affect your entire server. If you're okay with that then
I
> guess it's not a problem, but it could have performance implications on
> other queries that aren't having issues with parallelism. The MAXDOP hint
> would only affect the one query.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:%23lNE$r35EHA.824@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Thanks,
> How do I do for The MAXDOP hint
SELECT ...
FROM ...
WHERE ...
OPTION (MAXDOP 1)
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||Thanks,
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#zTbWH45EHA.3644@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:%23lNE$r35EHA.824@.TK2MSFTNGP11.phx.gbl...
>
> SELECT ...
> FROM ...
> WHERE ...
> OPTION (MAXDOP 1)
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
>
Friday, February 24, 2012
intra-query parallelism
Hi,
I am running sql 7 with sp3.
I got an error in running a sp.
The error message says, :Intra-query parallelism caused your server
command(process ID# 30) to deadlock. Rerun the query without intra-query
parallelism by using the query hint option (Maxdop 1).
Any ideas for this.
Thanks,Can you upgrade to Service Pack 4 and see if that remedies the issue?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:OpMRxD35EHA.828@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am running sql 7 with sp3.
> I got an error in running a sp.
> The error message says, :Intra-query parallelism caused your server
> command(process ID# 30) to deadlock. Rerun the query without intra-query
> parallelism by using the query hint option (Maxdop 1).
> Any ideas for this.
> Thanks,
>|||I do have sp4 installed
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:eXWhKH35EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Can you upgrade to Service Pack 4 and see if that remedies the issue?
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:OpMRxD35EHA.828@.TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > I am running sql 7 with sp3.
> >
> > I got an error in running a sp.
> > The error message says, :Intra-query parallelism caused your server
> > command(process ID# 30) to deadlock. Rerun the query without intra-query
> > parallelism by using the query hint option (Maxdop 1).
> >
> > Any ideas for this.
> >
> > Thanks,
> >
> >
>|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:%23zvTGa35EHA.3756@.TK2MSFTNGP14.phx.gbl...
> I do have sp4 installed
Okay, your original post said SP3...
Did you try the MAXDOP hint? If it doesn't decrease performance
significantly, go with that. Otherwise, you're going to have to call PSS.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||What I did was increase the value for intra-query-Paralellism.
Is that ok instead of trying try the MAXDOP hint?
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#H3rPc35EHA.4004@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:%23zvTGa35EHA.3756@.TK2MSFTNGP14.phx.gbl...
> > I do have sp4 installed
>
> Okay, your original post said SP3...
> Did you try the MAXDOP hint? If it doesn't decrease performance
> significantly, go with that. Otherwise, you're going to have to call PSS.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:uqE72i35EHA.2316@.TK2MSFTNGP15.phx.gbl...
> What I did was increase the value for intra-query-Paralellism.
> Is that ok instead of trying try the MAXDOP hint?
Well, that will affect your entire server. If you're okay with that then I
guess it's not a problem, but it could have performance implications on
other queries that aren't having issues with parallelism. The MAXDOP hint
would only affect the one query.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||Thanks,
How do I do for The MAXDOP hint
>that would only affect the one query.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#DluLl35EHA.1632@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:uqE72i35EHA.2316@.TK2MSFTNGP15.phx.gbl...
> > What I did was increase the value for intra-query-Paralellism.
> > Is that ok instead of trying try the MAXDOP hint?
>
> Well, that will affect your entire server. If you're okay with that then
I
> guess it's not a problem, but it could have performance implications on
> other queries that aren't having issues with parallelism. The MAXDOP hint
> would only affect the one query.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:%23lNE$r35EHA.824@.TK2MSFTNGP11.phx.gbl...
> Thanks,
> How do I do for The MAXDOP hint
> >that would only affect the one query.
SELECT ...
FROM ...
WHERE ...
OPTION (MAXDOP 1)
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||Thanks,
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#zTbWH45EHA.3644@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:%23lNE$r35EHA.824@.TK2MSFTNGP11.phx.gbl...
> > Thanks,
> >
> > How do I do for The MAXDOP hint
> > >that would only affect the one query.
>
> SELECT ...
> FROM ...
> WHERE ...
> OPTION (MAXDOP 1)
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
>
I am running sql 7 with sp3.
I got an error in running a sp.
The error message says, :Intra-query parallelism caused your server
command(process ID# 30) to deadlock. Rerun the query without intra-query
parallelism by using the query hint option (Maxdop 1).
Any ideas for this.
Thanks,Can you upgrade to Service Pack 4 and see if that remedies the issue?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:OpMRxD35EHA.828@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am running sql 7 with sp3.
> I got an error in running a sp.
> The error message says, :Intra-query parallelism caused your server
> command(process ID# 30) to deadlock. Rerun the query without intra-query
> parallelism by using the query hint option (Maxdop 1).
> Any ideas for this.
> Thanks,
>|||I do have sp4 installed
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:eXWhKH35EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Can you upgrade to Service Pack 4 and see if that remedies the issue?
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:OpMRxD35EHA.828@.TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > I am running sql 7 with sp3.
> >
> > I got an error in running a sp.
> > The error message says, :Intra-query parallelism caused your server
> > command(process ID# 30) to deadlock. Rerun the query without intra-query
> > parallelism by using the query hint option (Maxdop 1).
> >
> > Any ideas for this.
> >
> > Thanks,
> >
> >
>|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:%23zvTGa35EHA.3756@.TK2MSFTNGP14.phx.gbl...
> I do have sp4 installed
Okay, your original post said SP3...
Did you try the MAXDOP hint? If it doesn't decrease performance
significantly, go with that. Otherwise, you're going to have to call PSS.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||What I did was increase the value for intra-query-Paralellism.
Is that ok instead of trying try the MAXDOP hint?
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#H3rPc35EHA.4004@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:%23zvTGa35EHA.3756@.TK2MSFTNGP14.phx.gbl...
> > I do have sp4 installed
>
> Okay, your original post said SP3...
> Did you try the MAXDOP hint? If it doesn't decrease performance
> significantly, go with that. Otherwise, you're going to have to call PSS.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:uqE72i35EHA.2316@.TK2MSFTNGP15.phx.gbl...
> What I did was increase the value for intra-query-Paralellism.
> Is that ok instead of trying try the MAXDOP hint?
Well, that will affect your entire server. If you're okay with that then I
guess it's not a problem, but it could have performance implications on
other queries that aren't having issues with parallelism. The MAXDOP hint
would only affect the one query.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||Thanks,
How do I do for The MAXDOP hint
>that would only affect the one query.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#DluLl35EHA.1632@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:uqE72i35EHA.2316@.TK2MSFTNGP15.phx.gbl...
> > What I did was increase the value for intra-query-Paralellism.
> > Is that ok instead of trying try the MAXDOP hint?
>
> Well, that will affect your entire server. If you're okay with that then
I
> guess it's not a problem, but it could have performance implications on
> other queries that aren't having issues with parallelism. The MAXDOP hint
> would only affect the one query.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>|||"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:%23lNE$r35EHA.824@.TK2MSFTNGP11.phx.gbl...
> Thanks,
> How do I do for The MAXDOP hint
> >that would only affect the one query.
SELECT ...
FROM ...
WHERE ...
OPTION (MAXDOP 1)
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||Thanks,
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#zTbWH45EHA.3644@.tk2msftngp13.phx.gbl...
> "metoonyc" <metoonyc@.yahoo.com> wrote in message
> news:%23lNE$r35EHA.824@.TK2MSFTNGP11.phx.gbl...
> > Thanks,
> >
> > How do I do for The MAXDOP hint
> > >that would only affect the one query.
>
> SELECT ...
> FROM ...
> WHERE ...
> OPTION (MAXDOP 1)
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
>
Intra-query Paralleism caused your query to deadlock . . .
We often get the above message from our Sql Server 2000 Transactional Replication Distribution service. How do we implement the OPTION (MAXDOP 1) hint as directed? It seems I would have to modify the MS procedures. Can't do that. Any suggestions?
Michael
I originally posted this in the Replication forum but was ignored so I thought that perhaps a more "general" forum would attract a different kind of contributor . . .
If you cant give the OPTION (MAXDOP 1) query hint, you can change the Max Degree of Parallelism setting to 1, which in effect gives the same result.|||Are you suggesting that the max parallism for the entire server be changed to 1? Is that the solution? Will setting this option affect other queries in the system? What are other DBA's doing to solve this problem? I am concerned about the performance impact on the other queries in the server.
Thanks a lot Roji.
Subscribe to:
Posts (Atom)