Server Element (DTA)


Applies To: SQL Server 2016

Contains the identifying information for the server on which the databases reside that you want to tune.

    ...code removed here...  

Data type and lengthNone.
Default valueNone.
OccurrenceRequired once per DTAInput element.
Parent elementDTAInput Element (DTA)
Child elementsName Element for Server (DTA)

 Database Element for Server (DTA)

You can specify only one Server element for the DTAInput element. This element is of the ServerDetailsTypecomplexType name in the DTA XML schema. Do not confuse this Server element with the one that is the child of the Configuration element. For more information, see Server Element for Configuration (DTA).

The following example shows how to specify the Sales.SalesPerson table in the AdventureWorks database on SERVER001:


XML Input File Reference (Database Engine Tuning Advisor)

Community Additions