Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Antonio
Posting Yak Master
168 Posts |
 Posted - 2005-09-26 : 04:43:03
|
Greetings!  I am receiving the following error when I run my stored procedure. I have replaced some of my derived tables with temporary ones but still no joy. I am reluctant to use query hints so please could you suggest any other solutions?The error I get is shown below and I will also post the code if people need it.Intra-query parallelism caused your server command (process ID #115) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).Many thanks in advance. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-26 : 08:57:40
|
| Can you post the code???...removing/hiding confidential bits.... |
 |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2005-09-26 : 09:46:44
|
| Why don't you do just what is recommended, use query hint option (maxdop 1)? |
|
|
|
Antonio
Posting Yak Master
168 Posts |
Posted - 2005-09-26 : 12:14:01
|
Hi Andy and mmarovicmmarovic I don't think that using the query hint will solve the problem because that will ultimately slow down the running of my stored procedure. I have no idea how many processes the execution plan had planned to use but restricting to just the one will make the query run slower.The trouble is that I am joining on a partioned view containing over 700 million records so performance is vital.Andy,I'm wondering whether it's much value posting the entire query as it's overly complicated and it would require me to explain much of the business logic involved and that I can not do. Sorry!I have identified the culprit select statments (2 of them) but there is no easy fix as the fields joining on the view donot join on the clustered index (which would have speeded up the process).A complete re-design is required for what I am trying to achieve.The joy of datawarehousing  |
|
|
|
|
|
|
Parallelism problem