SQL Server Service Broker{3}


The article I read is called an Introduction to SQL Server Service Broker, by Deanna Dicken. As she mentions, “Service Broker is a technology built into SQL Server and utilized by the engine for its internal asynchronous processing.” SSB is a new architecture introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message based applications within the database itself.
There are some benefits of SSB including:
Reliability
Guaranteed Delivery
Replay-ability
Separation of concerns
Scalability
Priority processing
Guaranteed ordering
A SSB integration consists of Conversations or Conversation Groups, Message Types, Contracts, Services and Queues. Users can use T-SQL language to implement these pieces.

Service Broker is a technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered to be a dialog where two participants are involved. Service broker find applications when single or multiple SQL server instances are used. This functionality helps in sending messages to remote databases on different servers and processing of the messages within a single database. In order to send messages between the instances, the Service Broker uses TCP/IP.

I think SSB is a very useful tool to database applications. Database integration enhances application performance and simplifies administration. Message ordering and coordination for simplifies application development. Loose application coupling provides workload flexibility. Automatic activation allows applications to scale with the message volume. With SSB, users will be able to add reliable, scalable, asynchronous functionality to the database applications.

Reference

Dicken, Deanna: An Introduction to SQL Server Service Broker, Database Journal, July 9, 2012. http://www.databasejournal.com/features/mssql/an-introduction-to-sql-server-service-broker.html