| title |
TestServer Element (DTA) |
| ms.prod |
sql |
| ms.prod_service |
sql-tools |
| ms.technology |
tools-other |
| ms.topic |
conceptual |
| dev_langs |
|
| helpviewer_keywords |
|
| ms.assetid |
caa3547a-2cd5-47ad-ace2-a36752835cfe |
| author |
markingmyname |
| ms.author |
maghan |
| ms.manager |
jroth |
| ms.reviewer |
|
| ms.custom |
seo-lt-2019 |
| ms.date |
03/01/2017 |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
Specifies the test server to use when tuning a production server.
<TuningOptions>
<TestServer>...</TestServer>
...code removed here...
</TuningOptions>
| Characteristic |
Description |
| Data type and length |
string, unlimited length. |
| Default value |
None. |
| Occurrence |
Optional. Can use once for each TuningOptions element. |
For a usage example of this element, see Reduce the Production Server Tuning Load.
XML Input File Reference (Database Engine Tuning Advisor)