Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cube performance issue Expand / Collapse
Author
Message
Posted Wednesday, September 18, 2013 3:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:07 AM
Points: 140, Visits: 453
I am a new one in SSAS. I have cube of almost 800MB size without any partition and aggregation defined. User want data of almost all measures and at transaction level. When user browse data at DateKey level then It stuck for a long time and did not return any result. I have implemented partitions and Aggregations but result is same. In my scenario user want auditing and want 80% of cube data at row levels.

Should I go for Caching? Please suggest me any solution.
Post #1495826
Posted Wednesday, September 18, 2013 4:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:28 PM
Points: 13,263, Visits: 11,053
If the user almost always wants data at the transaction level, why build a cube in the first place? Cubes are designed to give fast aggregation results, but they are slow for detail rows. Maybe SSAS Tabular might be a better option? (if that's possible)



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1495836
Posted Wednesday, September 18, 2013 4:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:07 AM
Points: 140, Visits: 453
Is there any way to bring whole cube in memory.
Post #1495840
Posted Wednesday, September 18, 2013 5:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:28 PM
Points: 13,263, Visits: 11,053
In SSAS Tabular yes, because that's an entire in-memory solution.

I'm not sure you can get the entire SSAS cube into cache with SSAS multidimensional:
http://richardlees.blogspot.be/2011/12/why-doesnt-ssas-cache-entire-cube.html




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1495850
Posted Thursday, September 19, 2013 6:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:07 AM
Points: 140, Visits: 453
Is Tabular model is supported in SSAS 2008?
Post #1496351
Posted Thursday, September 19, 2013 6:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:28 PM
Points: 13,263, Visits: 11,053
No, it was introduced in SQL Server 2012.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1496363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse