process multiple partitions simultaneously

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Sampino - 04 Feb 2010 22:45 GMT

I’m trying to process 10 small partitions simultaneously in SSAS 2005 64 bit
against a SQL Server DB also 64 bit. The issue is that I only get 4
partitions processing simultaneously.

I have connected to SQL Server on the same machine as SSAS as well as
another machine. I have a similar setup going against an Oracle database and
all 10 partitions kick off at once, so I know it’s not a setting in SSAS. Is
this related to the SQL driver, or possibly the SQL Server DB?

I have tried the .Net SqlClient Data Provider, the OLE DB provider for Sql
Server and the SQL Native Client.

Any suggestions?

Reply to this Message

Joe Sampino - 08 Feb 2010 14:52 GMT

More info:

this seems to be related to the number of measures. if i have more than 25
measures the number of partitions is limited, but when i remove measures and
bring it down to 25, all 10 partitions process at once.

any advice as to how to allow all partitions with all measures? i have
about 75 measures.

> I’m trying to process 10 small partitions simultaneously in SSAS 2005 64 bit
> against a SQL Server DB also 64 bit. The issue is that I only get 4
[quoted text clipped - 9 lines]
>
> Any suggestions?

Reply to this Message