Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

TuningTimeInMin Element (DTA)

SQL Server 2012

Specifies the maximum length of a tuning session in minutes.

Copy 

<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.

Relationship

Elements

Parent element

TuningOptions Element (DTA)

Child elements

None

Description

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

Code

Copy 
<DTAInput>
  <Server>...</Server>
  <Workload>...</Workload>
  <TuningOptions>
    <TuningTimeInMin>720</TuningTimeInMin>
...code removed here...
</DTAInput>
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.