Database Element for Workload (DTA)
Applies to: SQL Server
Specifies the database where the workload trace table is located.
Syntax
<Workload>
<Database>
...code removed here...
</Database>
Element Characteristics
Characteristic | Description |
---|---|
Data type and length | None. |
Default value | None. |
Occurrence | Required once if no other type of workload is specified. You must specify an EventString, a File, or a Database child element for the Workload parent, but only one type can be used. For example, if you specify a workload with the Database element, you cannot also specify a workload with the File element in the same XML input file. |
Element Relationships
Relationship | Elements |
---|---|
Parent element | Workload Element (DTA) |
Child elements | Name Element for Database (DTA) Schema Element for Database (DTA) |
Remarks
This element is of the DatabaseDetailsTypecomplexType name in the Database Engine Tuning Advisor XML schema. Do not confuse this Database element with the one whose root parent is the Configuration element. (See Database Element for Configuration (DTA).)
Example
For a usage example of this Database element, see the code example in Workload Element (DTA).
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om