Poison Message Handling

Service broker provides automatic poison message detection, which disables the service queue upon five consecutive transaction rollbacks in trying to receive messages from the queue. However, an application should not rely on this feature for normal processing. Because automatic poison message detection stops the queue, this halts all processing for the application until the poison…

7

Service Broker Periodic Tasks

SSB receives notifications every 5 seconds from the SQL engine’s timer framework. SSB in turn counts these notifications and performs its various periodic maintenance tasks at different intervals. Tasks performed every notification: 1.       Internal activation feature of SSB uses monitors for each user queue. On every notification, these queue monitors adjust the number of internal activation…

0

A simple secure dialog with transport certificates

If you want to have a broker dialog between server instances, you have to be concerned with having a secure network connection, which in service broker terminology is called transport security. An effective way to accomplish this is using certificates to secure the broker endpoints. Then you can safely establish dialogs knowing that the communication context…

3