• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 668
  • Last Modified:

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.
0
Umesh
Asked:
Umesh
  • 2
1 Solution
 
dbaSQLCommented:
If you're not using OPTION (MAXDOP 1), you probably should be.  check out SELECT in BOL, specifically the OPTION clause
0
 
UmeshAuthor 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
 
dbaSQLCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now