Summary
Service Broker is one of those technologies that provide no benefit out-of-the-box, meaning that unless you take the effort to architect the database using Service Broker, there's no inherent benefit. However, if you do take the time to design the database using Service Broker, then you'll see significant scalability benefits as Service Broker queues workloads.
Service Broker can reduce the amount of work required to create distributed applications by handling all the internal notification and queuing logic between databases. In SQL Server 2012 Service Broker also supports sending and receiving remote messages between services in the new HA/DR solution named AlwaysOn Availability Groups.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
