TuningTimeInMin Element (DTA)

 

Applies To: SQL Server 2016

Specifies the maximum length of a tuning session in minutes.

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

CharacteristicDescription
Data type and lengthunsignedInt, unlimited length.
Default value480 minutes (8 hours).
OccurrenceRequired unless a value has been specified for the NumberOfEvents element.
RelationshipElements
Parent elementTuningOptions Element (DTA)
Child elementsNone

The following code example shows how to set 12 hours as the maximum tuning time:

<DTAInput>  
  <Server>...</Server>  
  <Workload>...</Workload>  
  <TuningOptions>  
    <TuningTimeInMin>720</TuningTimeInMin>  
...code removed here...  
</DTAInput>  

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions

ADD
Show: