This topic has not yet been rated - Rate this topic

File Element (DTA)

SQL Server 2012

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.

Syntax


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

Element Characteristics

Characteristic	Description
Data type and length	Use the string data type to specify the directory path to your workload file. For example: Copy <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.

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.

Element Relationships

Relationship	Elements
Parent element	Workload Element (DTA)
Child elements	None.

Example

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

Reference

XML Input File Reference (Database Engine Tuning Advisor)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD