Forum Discussion
tyr_chris
May 10, 2024Copper Contributor
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