none
Create/Delete partitions gets slower with every ROLAP partition

    Question

  • Hi

    We have a SSAS 2008 cube we use for reporting. It's an existing design so not sure the rationale behind it. For every report a user create we create 2 partitions, 1 MOLAP and 1 ROLAP. A ROLAP partition is only created if the user wants to see live data. We create these partitions using XMLA from a .Net service.

    Now the problem is as the number of ROLAP partitions grow, the CREATE and PROCESS partition gets slower. Essentially every new ROLAP partition hits cube with performance issues. It takes less than a second to create a partition when we start after clean-up and as we add around 100 ROLAP partitions by the EOD, it starts taking 2 minutes. We don't have very large data sets. The cube size stays around 1 GB and we keep clearing old partitions. Also, adding more MOLAP partitions doesn't make any difference. Only adding ROLAP patitions hit performance. We are creating separate partitions so we can only process one partition without processing the whole cube.


    Any help would be appreciated. Thanks.

    Nabeel


    • Edited by NabMo Wednesday, June 13, 2012 8:29 AM
    Wednesday, June 13, 2012 8:22 AM

All replies

  • Hi NabMo,

    Thank you for your question. 

    I am currently looking into this issue and will give you an update as soon as possible.

    Thank you for your understanding and support.

    Thanks,
    Bin Long

    TechNet Subscriber Support
    If you are
    TechNet Subscription user and have any feedback on our support quality, please send your feedback here.


    Bin Long

    TechNet Community Support

    Monday, June 18, 2012 9:51 AM
  • Any update on this? We are revisiting the problem but can't find a solution.

    Nabeel


    Nabeel

    Wednesday, November 21, 2012 11:17 AM