Slow Cubes

Posted on 2011-10-19
Last Modified: 2016-02-15
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.
Question by:thomaszhwang
    LVL 15

    Accepted Solution

    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.


    Author Closing Comment

    The guide is exactly what I want.  Thanks.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    731 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

    15 Experts available now in Live!

    Get 1:1 Help Now