ApplicationExecutionSettings Element (ADF)

Contains elements that specify execution settings for the application.

Syntax

<Application>
    ...
    <ApplicationExecutionSettings>

Element Characteristics

Characteristic	Description
Data type	None.
Default value	None.
Occurrence	Optional once per Application element.
Updates	Can be added and deleted when updating the application. Deleting this element and its child elements forces the application to use default values for the child elements.

Element Relationships

Relationship	Elements
Parent element	Application Element (ADF)
Child elements	QuantumDuration Element for ApplicationExecutionSettings (ADF) ChronicleQuantumLimit Element (ADF) SubscriptionQuantumLimit Element (ADF) ProcessEventsInOrder Element (ADF) PerformanceQueryInterval Element (ADF) EventThrottle Element (ADF) SubscriptionThrottle Element (ADF) NotificationThrottle Element (ADF) DistributorLogging Element (ADF) Vacuum Element (ADF)

Remarks

The ApplicationExecutionSettings element contains elements that define how the application runs. For more information about these settings, see Specifying Application Execution Settings.

Example

The following example shows a populated ApplicationExecutionSettings element using the following settings, in order:

• Generator quantum duration = 5 minutes.
• Chronicle quantum limit = 25 quanta (125 minutes, or just over 2 hours).
• Subscription quantum limit = 12 quanta (60 minutes, or 1 hour).
• The application uses sub-quantum sequencing.
• The performance query runs hourly.
• An event throttle that allows 5,000 events per quantum.
• The subscription throttle allows 3,000 subscriptions to be processed per quantum.
• A notification throttle that allows 5,000 notifications per quantum.
• The distributor logs notification pre-delivery information and notification delivery status, but not the notification text.
• Vacuuming runs from 3:00 A.M. to 5:00 A.M. and from 11:00 P.M. to 1:00 A.M. (UTC) every day, removing data older than 3 days.

<ApplicationExecutionSettings>
    <QuantumDuration>P0DT00H05M00S</QuantumDuration>
    <ChronicleQuantumLimit>25</ChronicleQuantumLimit>
    <SubscriptionQuantumLimit>12</SubscriptionQuantumLimit>
    <ProcessEventsInOrder>true</ProcessEventsInOrder>
    <PerformanceQueryInterval>P0DT01H00M00S</PerformanceQueryInterval>
    <EventThrottle>5000</EventThrottle>
    <SubscriptionThrottle>3000</SubscriptionThrottle>
    <NotificationThrottle>5000</NotificationThrottle>
    <DistributorLogging>
        <LogBeforeDeliveryAttempts>true</LogBeforeDeliveryAttempts>
        <LogStatusInfo>true</LogStatusInfo>
        <LogNotificationText>false</LogNotificationText>
    </DistributorLogging>
    <Vacuum>
        <RetentionAge>P3DT00H00M00S</RetentionAge>
        <VacuumSchedule>
            <Schedule>
                <StartTime>23:00:00</StartTime>
                <Duration>P0DT02H00M00S</Duration>
            </Schedule>
            <Schedule>
                <StartTime>03:00:00</StartTime>
                <Duration>P0DT02H00M00S</Duration>
            </Schedule>
        </VacuumSchedule>
    </Vacuum>
</ApplicationExecutionSettings>

See Also

Reference

Application Definition File Reference

Other Resources

Specifying Application Execution Settings
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance