Skip to content

dtaxml-element-dta.md

Latest commit

 

History

History
69 lines (52 loc) · 3.18 KB

dtaxml-element-dta.md

File metadata and controls

69 lines (52 loc) · 3.18 KB
Raw
title DTAXML Element (DTA)
description In the dta utility, the DTAXML element contains all elements that describe tuning input and output that the Database Engine Tuning Advisor generates.
ms.prod sql
ms.prod_service sql-tools
ms.technology tools-other
ms.topic conceptual
dev_langs
XML
helpviewer_keywords
DTAXML element
ms.assetid 3d9942ed-8a27-40db-a7c9-808984d914a2
author markingmyname
ms.author maghan
ms.reviewer
ms.custom seo-lt-2019
ms.date 03/14/2017

DTAXML Element (DTA)

[!INCLUDE 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="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 [!INCLUDEssManStudioFull], this value is used by F1 Help and Dynamic Help to locate possible reference topics in [!INCLUDEssNoVersion] 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 [!INCLUDEmsCoName] MSDN Library.

Example

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

See Also

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