DTAInput Element (DTA)


Applies To: SQL Server 2016

Contains the definition of XML input for Database Engine Tuning Advisor.

    ...code removed here...  

Data type and lengthNone.
Default valueNone.
OccurrenceOptional once per DTAXML element.
Parent elementDTAXML Element (DTA)
Child elementsServer Element (DTA)

 Workload Element (DTA)

 TuningOptions Element (DTA)

 Configuration Element (DTA)

This element is the root of the Database Engine Tuning Advisor input schema hierarchy. Input to Database Engine Tuning Advisor can be arguments that specify the servers whose databases you want to tune, workloads, tuning options, or a user-specified configuration.

For a usage example of the DTAInput element, see Simple XML Input File Sample (DTA).

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions