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

Posted on 2009-04-28
Last Modified: 2012-05-06
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.
Question by:ushastry
    LVL 17

    Expert Comment

    If you're not using OPTION (MAXDOP 1), you probably should be.  check out SELECT in BOL, specifically the OPTION clause
    LVL 26

    Author Comment

    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.
    LVL 17

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now