LogBeforeDeliveryAttempts Element (ADF)

Specifies whether the distributor makes an entry in the distribution log before delivering a notification.

Syntax

<ApplicationExecutionSettings>
    ...
    <DistributorLogging>
        <LogBeforeDeliveryAttempts>

Element Characteristics

Characteristic Description

Data type

Boolean.

Default value

true.

Occurrence

Optional once per DistributorLogging element.

Updates

Can be added, deleted, and modified when updating the application.

Element Relationships

Relationship Elements

Parent element

DistributorLogging Element (ADF)

Child elements

None.

Remarks

If the LogBeforeDeliveryAttempts value is true, Notification Services creates a row for each notification in the NSDistributionLog table before sending the notification. The distributor then logs predelivery information, including the notification ID, notification class, distributor, and delivery request time.

Your application can also log delivery status and notification text for all or just failed notifications by configuring the LogStatusInfo Element (ADF) and LogNotificationText Element (ADF).

A LogBeforeDeliveryAttempts value of true has a negative impact on application performance because Notification Services logs information one notification at a time. Most applications still perform well, but if you need to improve performance, set this value to false. Notification Services will still log notification text and status for failed notifications.

To view log data, use the NS<NotificationClassName>NotificationDistribution View.

Example

The following example shows how to configure the distributor to not log basic information about each notification.

<LogBeforeDeliveryAttempts>false</LogBeforeDeliveryAttempts>

See Also

Reference

Application Definition File Reference

Other Resources

Configuring Distributor Logging
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance