TuningTimeInMin Element (DTA)

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