TestServer Element (DTA)

TestServer Element (DTA)

 

Applies To: SQL Server 2016

Specifies the test server to use when tuning a production server.

  
<TuningOptions>  
  <TestServer>...</TestServer>  
   ...code removed here...  
</TuningOptions>  

CharacteristicDescription
Data type and lengthstring, unlimited length.
Default valueNone.
OccurrenceOptional. Can use once for each TuningOptions element.
RelationshipElements
Parent elementTuningOptions Element (DTA)
Child elementsNone.

For a usage example of this element, see Reduce the Production Server Tuning Load.

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions

ADD
Show:
© 2016 Microsoft