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.

    <Configuration [SpecificationMode="Relative" | "Absolute"]>
    ...code removed here...

Configuration Attribute



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



Data type and length


Default value



Optional. Can use once for each DTAInput element.

Legacy Code Example

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft