Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Service Broker (2005)
 Service broker Message Processing Order

Author  Topic 

Katie77
Starting Member

2 Posts

Posted - 2010-03-22 : 16:31:00
Hi,

I am new to Service brokers. I have a question regarding the message processing.

If I send 4-5 messages from one server to another in a span of milli seconds, are the messages processed in the same order that they are sent?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2010-03-22 : 18:32:28
yes. the order is guaranteed.

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.7 out!
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-22 : 23:59:15
quote:
In traditional reliable messaging applications, it's easy to get messages delivered out of order. For example, application A sends messages 1, 2, and 3. Application B receives and acknowledges 1 and 3, but experiences an error with 2, so application A resends it. However, now 2 is received after 3. Traditionally, programmers dealt with this problem by writing the application so that order didn't matter, or by temporarily caching 3 until 2 arrived so the messages could be processed in order. In contrast, Service Broker handles this transparently, so all messages in a dialog are received in the order sent, with no gaps in the message sequence.



http://msdn.microsoft.com/en-us/library/ms345108(SQL.90).aspx#sqlsvcbr_topic9
Go to Top of Page
   

- Advertisement -