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.
About MichaelThomassy
Michael Thomassy is a Program Manager in the Microsoft SQL Server development organization. Since joining Microsoft in 1995, Michael has been an Architect in Microsoft Consulting Services and Microsoft Technology Centers leading many large scale SQL Server implementations with dozens of Fortune 500 companies. In 2006, Michael joined the SQL Server Customer Advisory Team designing the largest and most complex SQL Server implementations specializing in OLTP and HA. Michael has a Bachelors degree in Computer Engineering from Auburn University.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
