TuningOptions Element (DTA)

Contains the tuning options for a specific tuning session.

Syntax

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

Element Characteristics

Characteristic	Description
Data type and length	None.
Default value	None.
Occurrence	Optional. If used, can only be used once for each DTAInput element.

Element Relationships

Relationship	Elements
Parent element	DTAInput Element (DTA)
Child elements	ReportSet element. For more information, see the Database Engine Tuning Advisor. TuningLogTable element. For more information, see the Database Engine Tuning Advisor. NumberOfEvents element. For more information, see the Database Engine Tuning Advisor. TuningTimeInMin Element (DTA) StorageBoundInMB Element (DTA) MaxKeyColumnsInIndex element. For more information, see the Database Engine Tuning Advisor. MaxColumnsInIndex element. For more information, see the Database Engine Tuning Advisor. MinPercentageImprovement element. For more information, see the Database Engine Tuning Advisor 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. RetainShellDB element. For more information, see the Database Engine Tuning Advisor.

Example

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

See Also

Reference

XML Input File Reference (DTA)

Help and Information

Getting SQL Server 2005 Assistance