partitioning-element-dta.md

title	Partitioning Element (DTA)
description	In the dta utility, the Partitioning element contains the partitioning scheme that you would like Database Engine Tuning Advisor to use during analysis.
author	rwestMSFT
ms.author	randolphwest
ms.date	03/01/2017
ms.service	sql
ms.subservice	tools-other
ms.topic	reference
ms.collection	data-tools
helpviewer_keywords	Partitioning element
dev_langs	XML

Partitioning Element (DTA)

[!INCLUDE SQL Server]

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

Syntax

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

Element Characteristics

Characteristic	Description
Data type and length	string, no maximum length.
Allowed values	NONE 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 value	NONE
Occurrence	Required once for the TuningOptions element, unless the DropOnlyMode element is used. If DropOnlyMode is used, you cannot use Partitioning. These elements are mutually exclusive.

Element Relationships

Relationship	Elements
Parent element	TuningOptions Element (DTA)
Child elements	None.

Example

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

See Also

XML Input File Reference (Database Engine Tuning Advisor)