This topic has not yet been rated - Rate this topic

Server Element for Configuration (DTA)

SQL Server 2012

Contains the identifying information for the server where you want Database Engine Tuning Advisor to evaluate the hypothetical configuration (specified by the Configuration element).

Syntax


<Configuration>
    <Server>
...code removed here...
    </Server>

Element Characteristics

Characteristic	Description
Data type and length	None.
Default value	None.
Occurrence	Required once per Configuration element.

Element Relationships

Relationship	Elements
Parent element	Configuration Element (DTA)
Child elements	Name Element for Server (DTA) Database Element for Configuration (DTA)

Relationship

Elements

Parent element

Configuration Element (DTA)

Child elements

Name Element for Server (DTA)

Database Element for Configuration (DTA)

Remarks

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

Example

For a usage example, see the XML Input File Sample with User-specified Configuration (DTA).

Reference

XML Input File Reference (Database Engine Tuning Advisor)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD