File Element (DTA)

File Element (DTA)

 

Applies To: SQL Server 2016

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>  

CharacteristicDescription
Data type and lengthUse 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 valueNone.
OccurrenceRequired 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.
RelationshipElements
Parent elementWorkload Element (DTA)
Child elementsNone.

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

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions

ADD
Show:
© 2016 Microsoft