| title | DropOnlyMode Element (DTA) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | tools-other | |
| ms.topic | conceptual | |
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 80960676-7581-4074-889b-80ee665963dd | |
| author | stevestein | |
| ms.author | sstein | |
| manager | craigg |
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.
<DTAInput>
...code removed...
<TuningOptions>
<DropOnlyMode>...</DropOnlyMode>
| 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 |
| Relationship | Elements |
|---|---|
| Parent element | TuningOptions Element (DTA) |
| Child elements | None. |
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:
<TuningOptions
<TuningTimeInMin>1440</Name>
<KeepExisting>ALIGNED</KeepExisting>
<DropOnlyMode />
</TuningOptions>