dbTalk Databases Forums  

Can Lazy Processing process partitions in parallel ?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Can Lazy Processing process partitions in parallel ? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Al
 
Posts: n/a

Default Can Lazy Processing process partitions in parallel ? - 02-15-2006 , 05:53 AM






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.

Reply With Quote
  #2  
Old   
Edward Melomed [MSFT]
 
Posts: n/a

Default Re: Can Lazy Processing process partitions in parallel ? - 02-15-2006 , 10:53 AM






To process partitions in parrallel you can use utility like this one:
http://www.microsoft.com/downloads/d...DisplayLang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights


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

Quote:
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.



Reply With Quote
  #3  
Old   
Jéjé
 
Posts: n/a

Default Re: Can Lazy Processing process partitions in parallel ? - 02-16-2006 , 07:35 AM



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 (AT) norely (DOT) micrsoft.com> wrote

Quote:
To process partitions in parrallel you can use utility like this one:
http://www.microsoft.com/downloads/d...DisplayLang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights


"Al" <Al (AT) discussions (DOT) microsoft.com> wrote in message
news:9B6065A9-CCB5-42DA-B82D-263DCE45E683 (AT) microsoft (DOT) 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.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.