SQL Server 2005 Service Broker, transactions & scalability

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Klaus Aschenbrenner (Klaus.Aschenbrenner_at_csharp.at)
Date: 12/18/04 

Date: Sat, 18 Dec 2004 16:31:22 +0100

Hi!

I'm currently reading through some whitepapers of SQL Server 2005 Service
Broker. It seems that this will be a very great technology to build
scalable, robust and asynchronous database applications. Currently I've one
questions that concerns me a little bit:

As far as I have read a new transaction is started as soon as Service Broker
reads out a message from a queue. The transaction is commited when
everything is done with the message without any exception. During the
beginning of the transaction and the commit of the transaction Service
Broker also checks for new message which are available within the same
conversation group and processes them accordingly.

So my question is now: are these new messages within the same conversation
group processed within the same transaction??? If yes this means that the
duration of the transactions gets more and more longer as more messages are
available within the same conversation group...

What is Service Broker doing when another message must be sent to a Service
Broker instance during the process of a current message? Then only the
sending of the new message is done within the same transaction, isn't it?

Thanks for your help

Klaus Aschenbrenner
MVP Visual C#
www.csharp.at
http://weblogs.asp.net/klaus.aschenbrenner

Relevant Pages

  • SQL Server 2005 Service Broker, transactions & scalability
    ... robust and asynchronous database applications. ... As far as I have read a new transaction is started as soon as Service Broker ... beginning of the transaction and the commit of the transaction Service ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Service Broker, transactions & scalability
    ... access that newsgroup via the web newsreader at: ... or you get the account information for accessing that newsgroup via your ... > Broker. ... > As far as I have read a new transaction is started as soon as Service ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Service Broker, transactions & scalability
    ... access that newsgroup via the web newsreader at: ... or you get the account information for accessing that newsgroup via your ... > Broker. ... > As far as I have read a new transaction is started as soon as Service ...
    (microsoft.public.sqlserver.programming)
  • One more detail
    ... All of the understated income is related to securities sales during 2004. ... so this must have been a manual audit, compaing broker information against ... on the Sch D on the "correct" date and for the correct amount. ... There is one transaction they high lighted that clearly is missing from my ...
    (misc.taxes)