tuningtimeinmin-element-dta.md

title	TuningTimeInMin Element (DTA) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	tools-other
ms.topic	conceptual
dev_langs	XML
helpviewer_keywords	TuningTimeInMin element
ms.assetid	4973d9ac-20fd-4ac3-bc9f-5d60e39fdb7d
author	stevestein
ms.author	sstein
manager	craigg

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

XML Input File Reference (Database Engine Tuning Advisor)