Edit

TuningTimeInMin Element (DTA)

  • Article

Applies to: SQL Server

Specifies the maximum length of a tuning session in minutes.

Syntax

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

Element Characteristics

Characteristic Description
Data type and length unsignedInt, unlimited length.
Default value 480 minutes (8 hours).
Occurrence Required unless a value has been specified for the NumberOfEvents element.

Element Relationships

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

Example

Description

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

Code

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

See Also

XML Input File Reference (Database Engine Tuning Advisor)