Parallel Element (XMLA)

Identifies commands to be run in parallel by the parent Batch command.

Syntax

<Batch>
   ....
   <Parallel maxParallel="Integer">
      <!-- One or more XMLA commands -->
   </Parallel>
   ....
</Batch>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Element Relationships

Relationship Element

Parent elements

Batch

Child elements

Any of the following:

Alter Element, Backup Element, Batch Element, BeginTransaction Element, Cancel Element, ClearCache Element, CommitTransaction Element, Create Element, Delete Element, DesignAggregations Element, Drop Element, Insert Element, Lock Element, MergePartitions Element, NotifyTableChange Element, Process Element, Restore Element, RollbackTransaction Element, Subscribe Element, Synchronize Element, Unlock Element, Update Element, UpdateCells Element,

Attributes

Attribute Description

maxParallel

Optional Integer attribute. Indicates the maximum number of threads on which to run commands in parallel. If not specified or set to 0, the instance of Microsoft SQL Server Analysis Services determines an optimal number of threads based on the number of processors available on the computer.

Remarks

See Also

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance