| title | Simple XML Input File Sample (DTA) | |
|---|---|---|
| description | This article contains a sample XML input file to use for tuning workloads to use with Database Engine Tuning Advisor. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 03/01/2017 | |
| ms.service | sql | |
| ms.subservice | tools-other | |
| ms.topic | reference | |
| ms.collection |
|
|
| helpviewer_keywords |
|
|
| dev_langs |
|
[!INCLUDE SQL Server]
Copy and paste this sample of a simple XML input file to use for tuning workloads into your favorite XML editor or text editor. Then replace the values specified for the Server, Database, Schema, Table, Workload, and TuningOptions elements with those for your specific tuning session. For more information about the attributes and child elements that you can use with these elements, see the XML Input File Reference (Database Engine Tuning Advisor). The following sample uses only a subset of available attribute and child element options.
[!code-xmlInputFileSamples#SimpleXMLInputFile]
Start and Use the Database Engine Tuning Advisor
XML Input File Reference (Database Engine Tuning Advisor)