Drillthrough on 2008 R2 very slow (it is MOLAP)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Drillthrough on 2008 R2 very slow (it is...

Drillthrough on 2008 R2 very slow (it is MOLAP)

Rate Topic

Display Mode

Topic Options

Author

Message

Stefan Wilms

Posted Friday, March 01, 2013 7:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 01, 2013 7:23 AM
Points: 1, Visits: 4

I have a Factgroup of Sales with the Dimensions Customer, Product, Time. A Query on 1 Productgroup, 1 Month and all Customers to return the Cell-Value I want to drillthrough needs 4 sec after a restart of SSAS. From relational DWH I know there are ca. 50.000 rows to return from drillthrough and sql-server needs 10 sec to fetch them. But the drillthrough needs 80 sek for default maxrows=10.000 rows and it needs more than 30 minutes for maxrows=50.000.
In Performance Monitor I see a lot of time spent caching. MdxStudio tells me the time is spent serializing.
Now I have a cube working fine for selects but doesn't work for drillthrough and it is MOLAP storage mode. Has anybody an idea what could be the cause, what I should check? I didn't find much about SSAS-performance when drilling through in the internet.

Post #1425507

« Prev Topic | Next Topic »

Permissions