Share via

TuningTimeInMin Element (DTA)

  • Article

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

Reference

XML Input File Reference (DTA)

Help and Information

Getting SQL Server 2005 Assistance