ApplicationExecutionSettings Element (ADF)

Contains elements that specify execution settings for the application.

Syntax

<Application>
    ...
    <ApplicationExecutionSettings>

Element Characteristics

Element Relationships

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