Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Specifies the test server to use when tuning a production server.
Syntax
<TuningOptions>
<TestServer>...</TestServer>
...code removed here...
</TuningOptions>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data type and length | string, unlimited length. |
| Default value | None. |
| Occurrence | Optional. Can use once for each TuningOptions element. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent element | TuningOptions Element (DTA) |
| Child elements | None. |
Example
For a usage example of this element, see Reduce the Production Server Tuning Load.