Skip to content

Latest commit

 

History

History
71 lines (54 loc) · 1.7 KB

File metadata and controls

71 lines (54 loc) · 1.7 KB
title TuningTimeInMin Element (DTA)
ms.prod sql
ms.prod_service sql-tools
ms.technology tools-other
ms.topic conceptual
dev_langs
XML
helpviewer_keywords
TuningTimeInMin element
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.

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)