Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

File Element (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 workload file. A workload is a set of Transact-SQL statements that execute against a database or databases that you want to tune. Workload files can be Transact-SQL scripts (.sql) or trace files (.trc). For more information, seeStart and Use the Database Engine Tuning Advisor.

<DTAInput>
  <Server>...</Server>
  <Workload>
    <File>...</File>
  </Workload>

Characteristic

Description

Data type and length

Use the string data type to specify the directory path to your workload file. For example:

<File>C:\Tuning\tun.sql</File>

Length limit is enforced by the server.

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 File element, then you cannot also specify a workload with the Database element in the same XML input file.

Relationship

Elements

Parent element

Workload Element (DTA)

Child elements

None.

For a usage example of this element, see Simple XML Input File Sample (DTA).

Community Additions

ADD
Show:
© 2015 Microsoft