Umesh
asked on
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.
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.
If you're not using OPTION (MAXDOP 1), you probably should be. check out SELECT in BOL, specifically the OPTION clause
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.