Forum Discussion

tyr_chris's avatar
tyr_chris
Copper Contributor
May 10, 2024

Service Broker Readers

Hi,

I am using service broker as a means to process events.

I have an activation procedure, that reads a single message, processes that message and then finishes.

My queue has 10 readers.

In the activation procedure I log the SPID and the login time of the session and my expectation would be, that each messages has a unique combination of SPID and login time of the session.

 

That is true most of the time. 

Sometimes however, a sessions seems to be re-used, meaning that more that one message (as per now always three) are processed by the same session (combination of SPID and login time).

 

Does the service broker recycle readers and if yes, is that something that can be configured/controlled?

 

Thanks a lot in advance

Chris

No RepliesBe the first to reply

Resources