Writer: Michael Thomassy
Contributors: Sanjay Mishra
Technical Reviewers: Lindsey Allen, Lubor Kollar, Mark Souza, Thomas Kejser, Burzin Patel
Published: March 2009
Service Broker provides support for building asynchronous messaging and queuing applications with the SQL Server Database Engine. This paper describes a large scale customer scenario and the techniques employed in scaling Service Broker to process tens of thousands of messages per second on one server.
Microsoft SQL Server Service Broker provides native support to the SQL Server Database Engine for asynchronous, transactional messaging. Finding Service Broker bottlenecks requires a similar approach to tuning any high-end OLTP database systems. This paper will describe the performance and scalability techniques applied to a real-world workload to increase overall system throughput. After you understand the workload and Service Broker system tables that are used, you’ll be able to find and remove the bottlenecks to scale Service Broker applications.
For more information, please refer to the Service Broker: Performance and Scalability Techniques whitepaper.
Pingback from Brent Ozar’s Reading List for MCM « SQL WARRIOR SPACE
Pingback from @MS_SQL_Server whitepapers New Path to Microsoft Certified Master: Microsoft SQL Server 2008 | sqlmashup
Pingback from New Path to Microsoft Certified Master: Microsoft SQL Server 2008 « SQL Consulting