What’s New in Service Broker

With the release of SQL Server 2008, Service Broker includes the following new features:

• A new diagnostic command-line utility called ssbdiagnose

• Prioritization of conversations

• Additional performance counters (for use with System Monitor)

• Enhanced configurability via SQL Server Management Studio (SSMS)

Although in versions of SQL Server prior to SQL Server 2005, it was possible to create structures analogous to some of the new database objects used with Service Broker (for example, using a table as a work queue), such implementations do not even come close to providing the reliability, ease of use, and scalability of Service Broker. This chapter introduces SQL Server’s native messaging-oriented framework. ...

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.