AS2005 SP2 parallel issue

Question

AS2005 SP2 parallel issue

Tiago Rente

Default port

Points: 1403
More actions
April 11, 2007 at 5:19 am

#172971

Hi,

In SQL Server Analysis Services 2005 SP2 (9.00.3050.00) we notice that not always AS2005 launches are request in parallel both in SQL Server Management Studio and in ASCMD (version 9.0.86.1 X86).

Does anyone have any solution to solve this?
Is there any parameter that needs to be changed?
After installing SP2 some of the server’s properties are no longer visible in the Analysis Services Properties. E.g., CoordinatorBuildMaxThreads.

Looking at ASCMD trace files and SQL Server Profiler traces it looks that the commands to process a dimension/partition have been scheduled but not lunched, how can we change this behavior?

Thanks in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

It's been a while but with ASCMD you supply an xmla command file? If yes, then have you set the degree of paralellism you want to run under? Same with Mgmt Studio, if you leave the default of 'server decides' on the level of parallelism it may decide to run none.

Steve.

Tiago Rente Default port Points: 1403 More actions · Answer 2

Hi Steve,

We are currently using the following XMLA script:

<

Process xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<

Object>

<

DatabaseID>$(DatabaseName)</DatabaseID>

<

CubeID>$(CubeName)</CubeID>

<

MeasureGroupID>$(MeasureGroupName)</MeasureGroupID>

<

PartitionID>$(PartitionName)</PartitionID>

</

Object>

<

Type>$(ProcessType)</Type>

<

WriteBackTableCreation>UseExisting</WriteBackTableCreation>

</

Process>

I.e., we are using the sequential mode within a transaction. We also tested with Parallel forcing "<Parallel MaxParallel="1">" but without sucess.

We also notice the problem if you process using the Management Studio. I.e., sometimes we try to process more than set of partitions in parallel (forcing the number of parallelism) but the 2nd, 3rd measure groups/partition from the same or different cubes wait for the first to finish.

Even with parallelism is started on AS2005 (as the profiler states) the commands are scheduled but do not start. How can we force the execution?

E.g., sometimes the queries on the relational take more than 60 minutes, so there is not workload on the server where the AS2005 is running.

Thanks.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 3

Hi Tiago,

Quick question on when you forced the MaxParallel, why did you set it to one? You'd need to set it to >=2 to see any parallelism?

Have you also read through the recommendations/dsicussion on parallel processing in the Analysis Services 2005 Performance Guide? It starts on p107. It also includes a counter ot two to watch to let you know whether to increase or decrease the parallelism count.

HTH,

Steve.