Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / February 2006

Tip: Looking for answers? Try searching our database.

Can Lazy Processing process partitions in parallel ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Al - 15 Feb 2006 11:53 GMT
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] - 15 Feb 2006 16:53 GMT
To process partitions in parrallel you can use utility like this one:
http://www.microsoft.com/downloads/details.aspx?FamilyID=a2eef773-6df7-4688-8211
-e02cf13cbdb4&DisplayLang=en


Edward.
Signature

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

> Hi,
>
[quoted text clipped - 13 lines]
>
> Thanks in advance.
Jéjé - 16 Feb 2006 13:35 GMT
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.

> To process partitions in parrallel you can use utility like this one:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=a2eef773-6df7-4688-8211
-e02cf13cbdb4&DisplayLang=en

[quoted text clipped - 17 lines]
>>
>> Thanks in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.