Learn how to a build a cloud-first strategyRegister Now

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

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.
1 Solution
Tim HumphriesCommented:
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

thomaszhwangAuthor Commented:
The guide is exactly what I want.  Thanks.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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