intra-query parallelism error in MS SQL Server 2000 Analysis Services

Hi,
We are getting following error while running queries over Analysis Server Cube Partition as below -

Data source provider error: Intra-query parallelism caused your server command (process ID #109) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).;

The version for Analysis services is Microsoft SQL Server  Analysis Services 2000 - 8.00.2039 with service pack SP4.
LVL 26
UmeshMySQL Principle Technical Support EngineerAsked:
Who is Participating?
 
dbaSQLConnect With a Mentor Commented:
I use this a lot -- Option (MAXDOP 1) -- my procs/queries run far faster, and
with far fewer concurrency issues.  i have found it is needed much more w/the previous
builds (v2000) than it is the current (v2008), but that's got to be due to the fact
that the engine is drastically improved in 08.

most of my stuff is OLTP, and like i said, i use it a lot.  (warehouses are way different)
with OLTP it's better to use the multiple cpu's simply to better allow for concurrent processing.  and to prevent the varied query from chewing all the cpu at once.

you could do it within the procedures/queries themselves, or you could do it at the server level.
possibly that would be better, and the client would be happier, as it  doesn't mandate changes to the queries themselves.
0
 
dbaSQLCommented:
If you're not using OPTION (MAXDOP 1), you probably should be.  check out SELECT in BOL, specifically the OPTION clause
0
 
UmeshMySQL Principle Technical Support EngineerAuthor Commented:
We had this option in our work list actually. But the client doesn't want to go for this option as the tool is Third party and rarely any change cane be made in queries.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.