NServiceBus/NServiceBus — pull request #1044 by abombss (2013-03-10 06:04:46+00:00)
Title: SQL Server Transport Push instead of Pull

Fixes #1040

Refactored to include a pluggable and extensible sqlbackoffstrategy. The default strategy keeps the current implementation intact. A second strategy was added to fallback to using a SqlDependency when no messages have been received for a given period of time on the endpoint.

If anyone has any suggestions on where or how to plug in integration tests I would appreciate it. I also would like some formal performance tests to document the impact of the new strategy.

Just running on my local machine with 2 workers 10 threads each I saw a 3 - 5% cpu utilization on SqlServer just from idle polling with the default strategy. Changing to the SqlDependency strategy there was 0% cpu utilization on my sql server. While not scientific and not running at full scale it does show promise with fairly idle endpoints using this strategy.

Please let me know if there is more I can contribute or change.

Thanks,
Adam