tuningtimeinmin-element-dta.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.collection	helpviewer_keywords	dev_langs
TuningTimeInMin Element (DTA)	In the dta utility, the TuningTimeInMin element specifies the maximum length of a tuning session in minutes.	rwestMSFT	randolphwest	03/01/2017	sql	tools-other	reference	data-tools	TuningTimeInMin element	XML

TuningTimeInMin Element (DTA)

[!INCLUDE 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)