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

Analysis Services CPU at 100%

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?  
0
agcsupport
Asked:
agcsupport
  • 2
1 Solution
 
PFrogCommented:
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.
0
 
agcsupportAuthor Commented:
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.
0
 
PFrogCommented:
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
   http://msdn2.microsoft.com/en-us/library/ms174946.aspx
   http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186197,00.html
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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