Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

TuningOptions Element (DTA)

Contains the tuning options for a specific tuning session.


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

Characteristic

Description

Data type and length

None.

Default value

None.

Occurrence

Optional. If used, can only be used once for each DTAInput element.

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.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.