Analysis Services CPU at 100%

Posted on 2007-10-15
Last Modified: 2013-11-16
We have a server running Analysis Services and clients using Excel to access data from the cube.  After a few users logon and start using the app to retrieve data from the cube the CPU usage starts increasing until it reaches near 100%.  Are there any counters or ways to find out what process or commands are executing and causing this issue?  
Question by:agcsupport
    LVL 18

    Expert Comment

    Are you pre-aggregating your cube data? Unless you design aggregations and then reprocess the cube, SSAS will have to calculate every query on the fly - causing high CPU usage.

    Author Comment

    We do pre-aggregate our numbers.  We have a few formulas that will calculate on the fly but not many.  I was wondering what logging feature I could use that would let me know what is executing at the time the CPU is near a 100%.  It is hovering between 90% to 98%.   I am sorry if my question is too vague but all I am looking for is to find out if there are any tools that shows me what is going on Analysis services when cpu is high and constant.  Thank you.
    LVL 18

    Accepted Solution

    Sorry I misunderstood
    You can use Profiler to see what's going on in the cube, in a similar way that you can with a normal SQL database.

    These links should give you some pointers,289483,sid87_gci1186197,00.html

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    This article describes some very basic things about SQL Server filegroups.
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now