Hi all,
I'm going to load 4 AS cubes from Oracle, 40 Million rows fact for
each one.

Each cube takes a long time to load (2-3 hours) due to a low avarage
of rows read per second (5000 up to 8000 rows per second) from the
Oracle Database.
I use the MS OLEDB Provider for Oracle to access the data and i know
that the
MS AS server is NOT busy... the CPUs (4) are consuming less than
20%...
Pagefile is not used and there's a lot of free memory.
So i think that the problem should be on the configuration of the
OLEDB provider or in the Oracle database that push out data slowly.

What do you think about it?
How can i improve OLEDB performances?

Thx
Cesare

Look at the general recommendations for improving processing performance in
the SSAS Performance Guide
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
My general rule-of-thumb is that a well-tuned, server-quality hardware
should be able to process about 1 million rows per minute *IF* the schema
has had the optimize schema wizard in the cube editor ran against it (this
minimizes the number of inner-joins generated by SSAS when forming the SQL
statement used in processing). If you are getting more than that -- GREAT.
If less than that, start looking for the bottleneck using the
recommendations in the white paper above.

This is only a general rule-of-thumb -- YOUR MILEAGE MAY VARY.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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.

"Cesare" <Cesare (AT) discussions (DOT) microsoft.com> wrote