SQL SERVER – Introduction to Service Broker

Service Broker is message queuing for SQL Server. It is used for sending emails and through Database Mails. You can read about SQL SERVER – Difference Between Database Mail and SQLMail here. Service Broker is feature which provides facility to SQL Server to send an asynchronous, transactional message.

So how it works is SQL Server uses Service Broker to send message from database to message queue. This message is then picked up by different processes to send this message to its destination. This separate processes can be using SMTP protocol. Sending and receiving processes can be done using entirely different system or SQL Server instance. It is not required that both the services are online at the same time. Sending services or Receiving services both are not required to be on line at the same time.

In summary, Services Broker follows traditional client-server architecture. Here client service initiates a conversation and receiving services takes messages and processes to send it to its destination.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

9 thoughts on “SQL SERVER – Introduction to Service Broker

  1. Pingback: SQL Server - Fix - Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process. Journey to SQL Authority with Pinal Dave

  2. Pingback: SQL SERVER - Change the Port of Service Broker Configuration Journey to SQL Authority with Pinal Dave

  3. Pingback: SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database Journey to SQL Authority with Pinal Dave

  4. Pingback: SQL SERVER - 2008 - Interview Questions and Answers - Part 6 Journey to SQL Authority with Pinal Dave

  5. HI Pinal,

    Nice Document given by you..
    which may be very helpful in my project.
    I have to fire automatic mail in project.

    so thanks a lot for this doc…

    Like

  6. Pingback: SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 15 of 31 Journey to SQLAuthority

  7. “Service Broker is message queuing for SQL Server. It is used for sending emails and through Database Mails.”…
    So simplistic, Pinal… Is that all you want to say?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s