file-element-dta.md

title	File Element (DTA)
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	tools-other
ms.topic	conceptual
dev_langs	XML
helpviewer_keywords	File element
ms.assetid	73dce835-9a80-4aef-8e0f-9dcf07dd5b80
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer
ms.custom	seo-lt-2019
ms.date	03/14/2017

File Element (DTA)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

Specifies the workload file. A workload is a set of [!INCLUDEtsql] statements that execute against a database or databases that you want to tune. Workload files can be [!INCLUDEtsql] 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: <File>C:\Tuning\tun.sql</File> Note that 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).

See Also

XML Input File Reference (Database Engine Tuning Advisor)