Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

659


Chapter 25: Asynchronous Messaging with Service Broker


25


Summary


Service Broker is one of those technologies that provide no benefi t out-of-the-box, mean-
ing that unless you take the effort to architect the database using Service Broker, there’s
no inherent benefi t. However, if you do take the time to design the database using Service
Broker, then you’ll see signifi cant scalability benefi ts as Service Broker queues workloads.

Service Broker can reduce the amount of work required to create distributed applications by
handling all the internal notifi cation 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.

c25.indd 659c25.indd 659 7/31/2012 9:21:38 AM7/31/2012 9:21:38 AM


http://www.it-ebooks.info
Free download pdf