Hi

I have a cube that procces 30 millions rows, the query execute very fast
and when write the data to the partitions is relatively fast, however when
the process is writting aggregations and indexs, it take a lot of time, I
tried to see what is consuming Memory or Procesator but I didn't get anything
wrong with this, somebody knows how can I solve this problem

Pd: Sorry by my english
--
Victor Hugo Pozo
MCAD Net

do you use 2005 or 2000?
does the CPU is at 100%?
what is your CPU & memory?


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

I use AS 2000
No, not even close
Pentium 4- 3Ghz and 2GB Ram
--
Victor Hugo Pozo
MCAD Net


"Jéjé" wrote:

and how many time the process takes?
does your cube contains a distinct count measure?

creating aggregations could take a lot of time if there is a lot of
aggregations and a high density in the content.
a parrallel process and partitions could help you.


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

It takes almost 3 hours
Yes, one measure is distinct count
There is just 4 mesaure in the cube, but have many dimensions
How can I create a parallel process ?

--
Victor Hugo Pozo
MCAD Net


"Jeje" wrote:

3h appear to be long.
I do a full process of 2 * 12millions of rows in 10 minutes using AS2005.

if you have a distinct count measure, put this one into a dedicated cube.
1 cube for the DCount measure and 1 cube for the other measures (sums, count
etc...)

search on the MS web site for the parrallel process utility.
but if you have only 1 CPU, the advantage of this utility is low, there is
an improvement, but a small one.



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

What I did?
I followed you suggest about create a new partition, in fact I divide the
fact table in 2 tables and make them sources for each partition
The other thing that I had to do is reduce the number of aggregations,
because the first aggregations save faster and the last aggregations take
a lot time for save I still dont know why
Anyway this reduced my time to 40 min, even with one proccesor

Thanks Jéjé for your help

--
Victor Hugo Pozo
MCAD Net


"Jéjé" wrote: