DTAXML element (DTA)

Applies to: SQL Server

The root element of a Database Engine Tuning Advisor XML input or output file, DTAXML contains all elements that describe tuning input and the tuning output that Database Engine Tuning Advisor generates.

Syntax

<DTAXML
    xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
    xmlns = "http://schemas.microsoft.com/sqlserver/2004/07/dta">
    ...code removed here...
</DTAXML>

Element attributes

Attribute	Description
xmlns:xsi	Required. Identifies the XML Schema Instance namespace. Attributes from this namespace are used to reference the schema that is used to validate the Database Engine Tuning Advisor XML file. Required value: http://www.w3.org/2001/XMLSchema-instance
xmlns	Required. Identifies the Database Engine Tuning Advisor namespace. If you edit the Database Engine Tuning Advisor XML file using the XML editor in SQL Server Management Studio, this value is used by F1 Help and Dynamic Help to locate possible reference articles in Microsoft Learn. Required value: Database Engine Tuning Advisor XML Schema namespace.

Element characteristics

Characteristic	Description
Data type and length	None.
Default value	None.
Occurrence	Required once per DTA XML file.

Element relationships

Relationship	Elements
Parent element	None
Child elements	DTAInput element (DTA) DTAOutput element. For more information, see Database Engine Tuning Advisor XML schema.

Remarks

For more information about XML namespaces, see Namespaces in an XML Document.

Examples

For examples of typical DTAXML elements, see XML Input File Samples (DTA).

Related content

• XML Input File Reference (Database Engine Tuning Advisor)
• Start and use the Database Engine Tuning Advisor