Export (0) Print
Expand All

XML Input File Reference (Database Engine Tuning Advisor)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Database Engine Tuning Advisor can use an XML input file to tune a database. This XML file designates which databases, tables, workload files or tables, and tuning options to use for the tuning session. You can also use this file to specify a user-specified configuration to perform "what-if" analysis.

A Database Engine Tuning Advisor XML input file contains a hierarchy of XML elements, each containing text or other elements that specify the tuning session settings. The Database Engine Tuning Advisor XML input file must conform to the standards for well-formed XML, so all element names are case sensitive. Elements are specified using Pascal case, which means that the first character is uppercase and the first letter of any subsequent concatenated word is uppercase.

All element values must conform to XML naming conventions. For more information about these conventions, see XML Textual Content in the MSDN Library.

Note that this reference is not comprehensive. For information about all the elements you can use to define XML input, refer to the Database Engine Tuning Advisor XML schema, DTASchema.xsd.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft