TuningTimeInMin Element (DTA)

Specifies the maximum length of a tuning session in minutes.

Składnia

<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

Przykład

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>

Zobacz także

Odwołanie

XML Input File Reference (Database Engine Tuning Advisor)