SQL Server Native Delayed Delivery

Component: SQL Server Transport
NuGet Package NServiceBus.Transport.SqlServer (7-pre)
This page targets a pre-release version and is subject to change prior to the final release.

The SQL Server transport can take advantage of native delayed delivery without the need to run the timeout manager. Instead, the transport creates dedicated infrastructure which delays messages using native SQL Server transport features.

When a message delay time lapses, SQL Server transport moves a batch of messages to the destination queue. Note that this means the exact time of delivering a delayed message is always an approximation.

The native delayed delivery of SQL Server transport is available only in endpoints that are not configured as send-only.

Configuration

The settings described in this section have default values as shown in the snippets. The settings can be fine-tuned to fit a particular system's needs, e.g. messages are checked for expiration more frequently resulting in more accurate delivery times.

Native delayed delivery mechanism has been introduced in version 3 of the transport. Older endpoints that use Timeout Manager can be migrated to the new mechanism by following the upgrade guide.

Table suffix

Delayed messages are stored in a dedicated table named endpoint-name.suffix. The value of the suffix can be specified in the configuration:

Copy code|Copy usings|Edit
transport.DelayedDelivery.TableSuffix = "Delayed";

Polling Interval

Messages are checked for expiration every second. The polling interval can be configured using:

Copy code|Copy usings|Edit
transport.DelayedDelivery.ProcessingInterval = TimeSpan.FromSeconds(5);

Polling Batch Size

On each query, a batch of messages is picked and dispatched. The maximal size of the batch can be specified with:

Copy code|Copy usings|Edit
transport.DelayedDelivery.BatchSize = 100;

Backwards compatibility

When upgrading to a version of the transport that supports native delayed delivery, it is safe to run a set of endpoints that include both endpoints using native delayed delivery as well as the timeout manager:

  • Endpoints with native delayed delivery can send delayed messages to endpoints using the timeout manager.
  • Endpoints with native delayed delivery can continue to receive delayed messages from endpoints using timeout manager.

Last modified