tuningoptions-element-dta.md

title	TuningOptions Element (DTA)
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	tools-other
ms.topic	conceptual
dev_langs	XML
helpviewer_keywords	TuningOptions element
ms.assetid	58a22ba1-8e03-411f-bd46-85e4540f217a
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer
ms.custom	seo-lt-2019
ms.date	03/01/2017

TuningOptions Element (DTA)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

Contains the tuning options for a specific tuning session.

Syntax

  
<DTAInput>  
    <Server>  
...code removed...  
    <Workload>...</Workload>  
    <TuningOptions>...</TuningOptions>  

Element Characteristics

Characteristic	Description
Data type and length	None.
Default value	None.
Occurrence	Optional. If used, can only be used once for each DTAInput element.

Element Relationships

Relationship	Elements
Parent element	DTAInput Element (DTA)
Child elements	ReportSet element. For more information, see the Database Engine Tuning Advisor XML schema. TuningLogTable element. For more information, see the Database Engine Tuning Advisor XML schema. NumberOfEvents element. For more information, see the Database Engine Tuning Advisor XML schema. TuningTimeInMin Element (DTA) StorageBoundInMB Element (DTA) MaxKeyColumnsInIndex element. For more information, see the Database Engine Tuning Advisor XML schema. MaxColumnsInIndex element. For more information, see the Database Engine Tuning Advisor XML schema. MinPercentageImprovement element. For more information, see the Database Engine Tuning Advisor XML schema TestServer Element (DTA) FeatureSet Element (DTA) Partitioning Element (DTA) DropOnlyMode Element (DTA) KeepExisting Element (DTA) OnlineIndexOperation Element (DTA) DatabaseToConnect Element (DTA) IgnoreConstantsInWorkload element. For more information, see the Database Engine Tuning Advisor XML schema. RetainShellDB element. For more information, see the Database Engine Tuning Advisor XML schema.

Example

For examples of the TuningOptions element, see the XML Input File Samples (DTA).

See Also

XML Input File Reference (Database Engine Tuning Advisor)