Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Building a Distributed Service Broker Application Expand / Collapse
Author
Message
Posted Sunday, July 07, 2013 11:25 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 7:01 PM
Points: 57, Visits: 248
Best instructions I've ever found (via Google) of setting up SSSB between two servers (or instances).

But ... The instructions terminate too early which leaves things in a SSSB Anti-Pattern called "Fire and Forget".

i.e. the InitiatorQueue of DatabaseA should do a RECIEVE of the messages and END CONVERSATION so that SSSB cleans up all it internal stuff. I.e. the message exchange must have an END CONVERSATION on BOTH sides.

If you don't do this your databases (both initiator and target) will grow enormously (depending on message frequency and/or size).

Remus explains: http://rusanu.com/2006/04/06/fire-and-forget-good-for-the-military-but-not-for-service-broker-conversations/

Maybe an update would be helpful as one of our brave souls followed the instructions six months ago and is now a bit red faced as he has to go back to the solution and clean it all up.
Post #1471040
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse