TuningTimeInMin Element (DTA)

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Specifies the maximum length of a tuning session in minutes.


...code removed...  

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



The following code example shows how to set 12 hours as the maximum tuning time:


...code removed here...  

See Also

XML Input File Reference (Database Engine Tuning Advisor)