TechNet
Export (0) Print
Expand All

TuningOptions Element (DTA)

 

Applies To: SQL Server 2016

Contains the tuning options for a specific tuning session.

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

CharacteristicDescription
Data type and lengthNone.
Default valueNone.
OccurrenceOptional. If used, can only be used once for each DTAInput element.
RelationshipElements
Parent elementDTAInput Element (DTA)
Child elementsReportSet 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.

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

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions

ADD
Show:
© 2016 Microsoft