TuningTimeInMin Element (DTA)
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>