Re: Cube Processing ETA table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 15:38:29 -0700

The general rule of thumb that I use is that on server-class hardware you
should be able to do at least 1 million rows per minute with no aggregates.
Like all rules of thumb your mileage may vary. I've seen faster (with higher
quality I/O subsystems; faster gigibit networks; etc.). I've see slower with
systems with lots of aggregates. But, in general, that is what I expect to
see.

If you have considerable less performance than that, check to see if you
have ran the Optimize Schema wizard in the cube editor and have simplified
your SQL statement as much as possible; or if your OLEDB provider (or ODBC
driver) is providing as quick a throughput as possible (this sometimes
happens with some of the older legacy data sources with older ODBC drivers). 

-- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rico Cali" <ricocali@hotmail.com> wrote in message
news:675e1895.0409100849.d40df44@posting.google.com...
> Does anyone have an ETA table of how long a cube will process if you
> have "x" number of dimension, "x" number of measures, "x" number of
> hiearachies, your processor, your memory, the number of bytes of your
> datawarehouse, etc.
>
> A formula of how to calculate this would also be appreciated.

Relevant Pages

  • Re: my uncle mick has passed
    ... nobody accused anybody of faking their own death. ... General rule of thumb: if it comes from AIOE and it's an unfamiliar ... dealing with any conservative. ...
    (rec.sport.football.college)
  • Re: Earth/Moon Gravity
    ... Another unstated fact is that a mass acts as if that mass were ... True for any solid shape, for all points outside that shape. ... certainly an important exception to the general rule of thumb, ...
    (rec.puzzles)
  • [Fwd: Rules of thumb (was:Re: HP : Massive strike and protest march today)]
    ... > that 20 years ago the general rule of thumb was that total compensation ... > of the use of temps, and maybe this is the reason why. ... workers is rapidly approaching the status of "urban myth". ...
    (comp.os.vms)
  • Re: Brown Bread
    ... 'camera' companies than electronic companies (Sony, ... General rule of thumb my ancient 3Mp Casio has optics from Canon... ...
    (uk.local.cumbria)
  • Re: performance comparision
    ... Is there some reason you can't just do the setting of the mark for ... probably force it to do a full table scan, switching your sequential ... perhaps complicated, SQL statement? ... There is a rule of thumb about when to use sql versus pl/sql: ...
    (comp.databases.oracle.server)