title
TuningTimeInMin Element (DTA)
ms.prod
sql
ms.prod_service
sql-tools
ms.technology
tools-other
ms.topic
conceptual
dev_langs
helpviewer_keywords
ms.assetid
4973d9ac-20fd-4ac3-bc9f-5d60e39fdb7d
author
markingmyname
ms.author
maghan
ms.manager
jroth
ms.reviewer
ms.custom
seo-lt-2019
ms.date
03/01/2017
TuningTimeInMin Element (DTA)
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md ]
Specifies the maximum length of a tuning session in minutes.
<DTAInput>
...code removed...
<TuningOptions>
<TuningTimeInMin>...</TuningTimeInMin>
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.
The following code example shows how to set 12 hours as the maximum tuning time:
<DTAInput>
<Server>...</Server>
<Workload>...</Workload>
<TuningOptions>
<TuningTimeInMin>720</TuningTimeInMin>
...code removed here...
</DTAInput>
XML Input File Reference (Database Engine Tuning Advisor)