Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Drillthrough on 2008 R2 very slow (it is MOLAP) Expand / Collapse
Posted Friday, March 1, 2013 7:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 28, 2015 6:51 AM
Points: 3, Visits: 23
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 »

Add to briefcase

Permissions Expand / Collapse