Why use Service Broker?

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  May 4, 2005 at 1:56 am

  #166897

  Hi,

  I've been pondering about SQL Server Service Broker and, whilst I understand what it is, I'm trying to figure out when and where it would be used.

  Primarily, are there any situations where Service Broker is a better option that MSMQ?

  What characteristics of a system should be considered when deciding whether to use Service Broker or MSMQ?

  What are the advantages of putting queuing into the DB?

  What are the disadvantages of putting queuing into the DB?

  Of course, I can read all the marketing blurb about this but I'd prefer to get some opinions from people on the ground.

  Thanks in advance!

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson

• May 9, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 9, 2005 at 8:49 am

  #557625

  I haven't had the time to read it yet, but I noted that Rushi Desai made a blog post about replacing an MSMQ q with a service broker q.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  May 9, 2005 at 10:28 am

  #557651

  I suspect it's a choice that you make for ease of admin or skillsets rather than a technical reason.

• caffeinated

  Ten Centuries

  Points: 1271

  More actions

  May 11, 2005 at 12:18 pm

  #558195

  According SQL 2005 BOL, (search "Install Messaging Objects" on BOL) Service Broker is required for Database Mail (aka SQLiMail) functionality.