EventString Element (DTA)


Applies To: SQL Server 2016

Specifies a Transact-SQL script workload directly in the XML input file.

    <EventString Weight="...">  
    ...code removed here...  

WeightOptional. Specifies the query weight factor (a factor of importance) for the specified event. Use a float data type to specify the weight. For example, Weight="100.01". The minimum value you can specify for Weight is "0".
Data type and lengthstring, length is unlimited.
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 EventString element, then you cannot also specify a workload with the File element in the same XML input file.
Parent elementWorkload Element (DTA)
Child elementsNone.

For a usage example of this element, see the XML Input File Sample with Inline Workload (DTA) .

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions