This topic has not yet been rated - Rate this topic

DropOnlyMode Element (DTA)

SQL Server 2012

SQL Server 2005

Specifies that Database Engine Tuning Advisor should only consider dropping existing indexes, indexed views, or partitions during the tuning session. No new physical design structures are considered when this tuning option is specified.

Syntax


<DTAInput>
...code removed...
    <TuningOptions>
      <DropOnlyMode>...</DropOnlyMode>

Element Characteristics

Characteristic	Description
Data type and length	None.
Default value	None.
Occurrence	Optional. Can use only once for each TuningOptions element. Cannot be used if the following elements are specified in the TuningOptions element: FeatureSet Element (DTA) Partitioning Element (DTA) KeepExisting Element (DTA) is set to ALL

Characteristic

Description

Data type and length

None.

Default value

None.

Occurrence

Optional. Can use only once for each TuningOptions element. Cannot be used if the following elements are specified in the TuningOptions element:

FeatureSet Element (DTA)
Partitioning Element (DTA)
KeepExisting Element (DTA) is set to ALL

Element Relationships

Relationship	Elements
Parent element	TuningOptions Element (DTA)
Child elements	None.

Example

The following example shows the TuningOptions section of a Database Engine Tuning Advisor XML input file where the DropOnlyMode is specified. In this example the tuning time is limited to 24 hours (1440 minutes) and all existing clustered and nonclustered indexes will be considered for dropping:

xmlLang

<TuningOptions
  <TuningTimeInMin>1440</Name>
  <KeepExisting>ALIGNED</KeepExisting>
  <DropOnlyMode />
</TuningOptions>

Reference

XML Input File Reference (Database Engine Tuning Advisor)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD