Slow Cubes

I have a cube running in the production environment that runs really slow.  I'm not really sure what's going on.  What steps should I take to find out the cause and potentially improve the performance?  Thanks.
thomaszhwangAsked:
Who is Participating?
 
Tim HumphriesDirectorCommented:
Hi - need more information here. When you say 'cubes run slowly' you presumably mean that queries run against the cubes run slowly. Post the details of a slow running query, the volumes of data in the referenced fact tables and dimensions and a screenshot of your fact table and dimension hierarchy design and it should be possible to point you in the right direction.

For more general help, you could search google for 'Analysis Services Performance guide'. There are links the MS white papers and documentation, e.g. http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17303

Tim
0
 
thomaszhwangAuthor Commented:
The guide is exactly what I want.  Thanks.
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.

All Courses

From novice to tech pro — start learning today.