Export (0) Print
Expand All

Configuration Element (DTA)

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 Attribute

Description

SpecificationMode

Optional. 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">
    

Characteristic

Description

Data type and length

None.

Default value

None.

Occurrence

Optional. Can use once for each DTAInput element.

Community Additions

ADD
Show:
© 2015 Microsoft