DTAXML Element (DTA)

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="https://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 topics in SQL Server Books Online.

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 (see Database Engine Tuning Advisor XML schema for information)

Remarks

For more information about XML namespaces, see Namespaces in an XML Document in the Microsoft MSDN Library.

Example

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

See Also

Reference

XML Input File Reference (DTA)

Other Resources

How to: Create XML Input Files

Help and Information

Getting SQL Server 2005 Assistance