Partitioning Element (DTA)

 

Applies To: SQL Server 2016

Contains the partitioning scheme that you would like Database Engine Tuning Advisor to use during analysis.

  
<DTAInput>  
...code removed...  
    <TuningOptions>  
      <Partitioning>...</Partitioning>  

CharacteristicDescription
Data type and lengthstring, no maximum length.
Allowed valuesNONE
No partitioning.

 FULL
Full partitioning. (Enhances performance.)

 ALIGNED
Aligned partitioning only. (Enhances manageability.)

Use only one of these values with this element.

 ALIGNED means that in the recommendation generated by Database Engine Tuning Advisor every proposed index is partitioned in exactly the same way as the underlying table for which the index is defined. Nonclustered indexes on an indexed view are aligned with the indexed view.
Default valueNONE
OccurrenceRequired once for the TuningOptions element, unless the DropOnlyMode element is used. If DropOnlyMode is used, you cannot use Partitioning. These elements are mutually exclusive.
RelationshipElements
Parent elementTuningOptions Element (DTA)
Child elementsNone.

For a usage example of this element, see the Simple XML Input File Sample (DTA).

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions

ADD
Show: