Service Broker Enhancements

SQL Server 2008 provides the following enhancements to Service Broker:

• Support for conversation priorities. This support allows administrators and developers to specify that messages for important Service Broker conversations are sent and received before messages from less important conversations to ensure that low-priority work does not block higher-priority work.

• The new ssbdiagnose command-prompt utility to analyze and diagnose Service Broker configurations and conversations.

• A new performance object and counters that report how often Service Broker dialogs request transmission objects and how often inactive transmission objects are written to work tables in tempdb.

• Support for Service Broker in SQL Server ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.