Very slow processing on SSAS2005 Std (Core Duo, MSSQL on same box, different disks for DB and AS)...

Hi All,

I have a very simple cube (my bank account transactions), with around 500
fact table rows, a handful of very small dimensions, including a date
dimension built by SSAS.

When I process this cube, it takes 2 mins+, the majority of the time being
spent processing the dimensions.

I've profiled MSSQL (where the 'subject matter' DB is), and the sum total of
duration for queries used to build the cube amounts to around a second.

I'm struggling to see why SSAS would be having a hard time building this
cube - any thoughts?

Many thanks,

Will Alber.


.

Relevant Pages

  • Re: Fairly Large Cube-Performance Improvement recommendations
    ... move) if the cube has large number of dimensions. ... We have 30 dims in the cube and the storage design wizard taked about 45 ... > 1) execute a fairly long query, let's say one that runs for 20 seconds. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager Operations extremely slow
    ... Each of the cubes have 12 partitions with monthly slices. ... Counting multiple hierarchies as dimensions, we 10 regular dimensions and 6 ... The first time we bring up the cube edit it take 1 min 20 secs, ...
    (microsoft.public.sqlserver.olap)
  • Spoof shared dimension for virtual cube
    ... just getting back into Analysis Services again, ... Two cubes, ... Cube1 has 10 more dimensions, ... I'm sure it's possible to get this result with MDX (which I'm still not ...
    (microsoft.public.sqlserver.olap)
  • How to create a "Stock" cube ?
    ... and dimensions, but now I must take it one step further and create what I ... The cube will have dimensions like: ... Itemnumber, Itemgroup, Stocklocation, Blocked, Customs classification ... Thus selecting a particular itemnumber ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube very slow to querying when in the middle of a process
    ... how many partitions are you dealing with if you add new ... >> Well, when incrementally updating dimensions, AS2k will automatically ... >> refresh the cube partitions below it which may have an impact on this. ... >> point where you may want to have reporting OLAP cubes and processing OLAP ...
    (microsoft.public.sqlserver.olap)
Loading