|
Home > Archive > MS SQL Data Warehousing > February 2006 > Can Lazy Processing process partitions in parallel ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can Lazy Processing process partitions in parallel ?
|
|
|
| Hi,
we are processing a large number od small(ish) partitions, and I was
wondering if using Lazy Processing would process the partitions in parallel.
The partitions are built in serial. If Lazy Processing is set, would AS2000
process each partition in turn on the background thread? Or would it process
multiple partitons in parallel, making use of all available CPUs?
The partitions are being processed rather than the Cube because not all the
partitions need to be updated.
Thanks in advance.
| |
| Edward Melomed [MSFT] 2006-02-15, 11:23 am |
| To process partitions in parrallel you can use utility like this one:
http://www.microsoft.com/downloads/...&DisplayLang=en
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Al" <Al@discussions.microsoft.com> wrote in message
news:9B6065A9-CCB5-42DA-B82D- 263DCE45E683@microso
ft.com...
> Hi,
>
> we are processing a large number od small(ish) partitions, and I was
> wondering if using Lazy Processing would process the partitions in
> parallel.
>
> The partitions are built in serial. If Lazy Processing is set, would
> AS2000
> process each partition in turn on the background thread? Or would it
> process
> multiple partitons in parallel, making use of all available CPUs?
>
> The partitions are being processed rather than the Cube because not all
> the
> partitions need to be updated.
>
> Thanks in advance.
| |
|
| the question is about the lazy aggregation process ;-)
this process is a background process which evaluate each partition 1 after
1.
you can't change this behavior. so there is no parrallel lazy aggregation
process.
"Edward Melomed [MSFT]" <edwardm@norely.micrsoft.com> wrote in message
news:OYNArBlMGHA.2992@tk2msftngp13.phx.gbl...
> To process partitions in parrallel you can use utility like this one:
> http://www.microsoft.com/downloads/...&DisplayLang=en
>
> Edward.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
>
> "Al" <Al@discussions.microsoft.com> wrote in message
> news:9B6065A9-CCB5-42DA-B82D- 263DCE45E683@microso
ft.com...
>
>
|
|
|
|
|