Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

EventString Element (DTA)

SQL Server 2012

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

Copy 

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

Attribute

Description

Weight

Optional. 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".

Characteristic

Description

Data type and length

string , length is unlimited.

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 EventString element, then you cannot also specify a workload with the File 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 the XML Input File Sample with Inline Workload (DTA) .

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.