Service Broker Fire and Forget

• emile.milne

  Default port

  Points: 1407

  More actions

  November 28, 2012 at 8:53 am

  #267505

  Can someone please direct me to some hardcore evidence that FIRE and FORGET set up is not good and can cause x amount of issues.

  I need something written by a MVP or something directly from MS. To prove my point.

  Tempdb is filling up, sys.conversation_endpoints is clearing out but I believe that is due to the END CONVERSATION With Clean up.

  Service broker spid has been identified as the culprit.

  My impressions are that the endpoints/Work tables are being left in the TEMPDB. The last status of the conversation is DI DISCONNECTED_INBOUND. Remote side has issued end convo but the target hasn’t ended properly.

  I need this to be proven to cause issues to force a rewrite of the SB.

• Lowell

  SSC Guru

  Points: 323518

  More actions

  November 28, 2012 at 9:50 am

  #1563278

  i found a few articles, all with explanations:

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

  http://social.msdn.microsoft.com/Forums/en-AU/sqlservicebroker/thread/9ebba1ac-79b3-4eac-a2f6-41def13154cb

  http://www.nootz.net/index.php/service-broker-fire-and-forget-messages.html

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  November 28, 2012 at 10:13 am

  #1563303

  rusanu.com is a good source. I'd ask him further questions if you need them. He's done a lot of SB work.

• Bobby Glover

  SSCarpal Tunnel

  Points: 4143

  More actions

  November 28, 2012 at 10:38 am

  #1563326

  Thanks

  Both of you.