Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Analysis Services CPU at 100%

Posted on 2007-10-15
3
Medium Priority
?
3,406 Views
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?  
0
Comment
Question by:agcsupport
  • 2
3 Comments
 
LVL 18

Expert Comment

by:PFrog
ID: 20083892
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
 

Author Comment

by:agcsupport
ID: 20094040
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
 
LVL 18

Accepted Solution

by:
PFrog earned 2000 total points
ID: 20101108
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

564 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