Events
Ottieni gratuitamente la certificazione in Microsoft Fabric.
Nov 19, 11 PM - Dec 10, 11 PM
Per un periodo di tempo limitato, il team della community di Microsoft Fabric offre buoni per esami DP-600 gratuiti.
Prepara oraDTAXML 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.
<DTAXML
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://schemas.microsoft.com/sqlserver/2004/07/dta">
...code removed here...
</DTAXML>
| 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 |
| Characteristic | Description |
|---|---|
| Data type and length | None. |
| Default value | None. |
| Occurrence | Required once per DTA XML file. |
| Relationship | Elements |
|---|---|
| Parent element | None |
| Child elements | DTAInput Element (DTA) DTAOutput Element (see Database Engine Tuning Advisor XML schema for information) |
For more information about XML namespaces, see Namespaces in an XML Document.
For examples of typical DTAXML elements, see XML Input File Samples (DTA).
XML Input File Reference (Database Engine Tuning Advisor)
Start and Use the Database Engine Tuning Advisor