Skip to content

droponlymode-element-dta.md

Latest commit

 

History

History
68 lines (49 loc) · 2.16 KB

droponlymode-element-dta.md

File metadata and controls

68 lines (49 loc) · 2.16 KB
title DropOnlyMode Element (DTA)
ms.prod sql
ms.prod_service sql-tools
ms.technology tools-other
ms.topic conceptual
dev_langs
XML
helpviewer_keywords
DropOnlyMode element
ms.assetid 80960676-7581-4074-889b-80ee665963dd
author markingmyname
ms.author maghan
ms.manager jroth
ms.reviewer
ms.custom seo-lt-2019
ms.date 03/01/2017

DropOnlyMode Element (DTA)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

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

Data type and length

Default value

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

Element Relationships

Parent element: TuningOptions Element (DTA)

Child elements

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:

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

See Also

XML Input File Reference (Database Engine Tuning Advisor)