Database Element for Workload (DTA)

Database Element for Workload (DTA)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Specifies the database where the workload trace table is located.

   ...code removed here...



Data type and length


Default value



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.

This element is of the DatabaseDetailsType complexType 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).)

For a usage example of this Database element, see the code example in Workload Element (DTA).

Community Additions

© 2016 Microsoft