Configuration Element (DTA)

 

Applies To: SQL Server 2016

Specifies a user-specified configuration consisting of existing and hypothetical physical design structures for the Database Engine Tuning Advisor to analyze when tuning a workload.

  
<DTAInput>  
    <Server>...</Server>  
    <Workload>...</Workload>  
    <TuningOptions>...</TuningOptions  
    <Configuration [SpecificationMode="Relative" | "Absolute"]>  
    ...code removed here...  
    </Configuration>  
</DTAInput>  

Configuration AttributeDescription
SpecificationModeOptional. Specifies whether Database Engine Tuning Advisor should analyze the specified configuration in relation to the current existing configuration, or as a completely new, standalone one. Use a string data type to specify this attribute with one of the following allowed values:

 Relative:
Evaluates the specified configuration in relation to the current existing configuration of physical design structures (indexes, indexed views, partitioning) in the database that is being tuned. For example:

 <Configuration SpecificationMode="Relative">

 Absolute:
Evaluates the specified configuration as a standalone configuration. When Absolute is specified, Database Engine Tuning Advisor does not consider the existing configuration. For example:

 <Configuration SpecificationMode="Absolute">
CharacteristicDescription
Data type and lengthNone.
Default valueNone.
OccurrenceOptional. Can use once for each DTAInput element.
RelationshipElements
Parent elementDTAInput Element (DTA)
Child elementsServer Element for Configuration (DTA)

For a usage example of this element, see the XML Input File Sample with User-specified Configuration (DTA).

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions

ADD
Show: