Managing Service Broker Conversations

Wednesday Dec 9th 2009 by DatabaseJournal.com Staff
Share:

Here’s several methods that prevent data loss and improve performance.

[From SQL Server Magazine]

SQL Server 2005’s Service Broker uses a new concept of a dialog conversation. Service Broker conversations are conceptually similar to T-SQL connections, but there are a few important differences that could affect performance, and even have the potential for data loss. I’ll discuss a few common pitfalls related to Service Broker conversation management and provide some simple solutions and workarounds.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=103131

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved