Service Broker – Bookmarker
Since SQL Server 2005 this feature of Service Broker has been in the outside world but in my opinion is an underutilized feature. In SQL Server 2008 the capabilities atleast from a UI has been addressed partially via the Management Studio which was one of the biggest drawback for using this feature.
Quick Intro - Service Broker provides queuing, scalable and reliable messaging for inside SQL Server. Service Broker is used both for applications that use a single SQL Server instance and applications that distribute work across multiple instances. It is completely an asynchronous programming model which reduces the response time back to the application rather than getting blocked ... For highly throughput systems this sort of reliable delivery and speed is very essential. There are multiple advantages of Service Broker when compared to other solutions like MSMQ, let me outline couple of them for you -
- Message ordering and coordination simplified
- Loose application coupling provides workload flexibility
- Related message locking allows more than one instance of an application to process messages from the same queue without explicit synchronization
- Automatic activation allows applications to scale with the message volume
and many more …
I thought of pointing you some of the awesome resources on SB from the product team already online.
SQLServer SSB Team Blog - http://blogs.msdn.com/sql_service_broker/
Remus' blogs - http://rusanu.com/blog/
Other MSDN resources that are also useful are -
Overview - An Introduction to SQL Server Service Broker - http://msdn2.microsoft.com/en-us/library/ms345108.aspx
Links to Service Broker Architecture and Implementation - http://msdn2.microsoft.com/en-us/library/ms166043.aspx
Service Broker Tutorials - http://msdn2.microsoft.com/en-us/library/bb839489.aspx
Online Video Training
MSDN Webcast: Introducing Service Broker in SQL Server 2005—Level 200
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032263311
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032289816&EventCategory=5&culture=en-US&CountryCode=US
Lastly, the Technet Site http://technet.microsoft.com/en-us/sqlserver/bb671396.aspx has several white papers, books, and blogs on Broker.