DatabaseToConnect Element (DTA)
Applies to: SQL Server
Specifies the first database to which Database Engine Tuning Advisor connects when tuning a workload.
Syntax
<TuningOptions>
...code removed here...
<DatabaseToConnect>...</DatabaseToConnect>
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 |
Remarks
Use DatabaseToConnect to specify the name of the first database to which you want Database Engine Tuning Advisor to connect when it starts the tuning session. You can specify only one database with this element. If multiple database names are specified, Database Engine Tuning Advisor returns an error.
Example
For a usage example, see the XML Input File Sample with Inline Workload (DTA).