Re: SQL Server 2005 Service Broker, transactions & scalability
From: Stephen Dybing [MSFT] (stephd_at_online.microsoft.com)
Date: 12/20/04
- Next message: Bill Henning: "Storage Impact of nullable varchar column?"
- Previous message: Jacco Schalkwijk: "Re: Table row count (cardinality)"
- In reply to: Klaus Aschenbrenner: "SQL Server 2005 Service Broker, transactions & scalability"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Dec 2004 09:08:01 -0800
This would be a good question to post to
microsoft.private.sqlserver2005.relationalserver.servicebroker. :-) You can
access that newsgroup via the web newsreader at:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us&NewsGroup=microsoft.private.sqlserver2005.relationalserver.servicebroker,
or you get the account information for accessing that newsgroup via your
favorite newsreader by scrolling down in the top middle pane of
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us.
-- Sincerely, Stephen Dybing This posting is provided "AS IS" with no warranties, and confers no rights. Please reply to the newsgroups only, thanks. "Klaus Aschenbrenner" <Klaus.Aschenbrenner@csharp.at> wrote in message news:%23kBieaR5EHA.1260@TK2MSFTNGP12.phx.gbl... > 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 > >
- Next message: Bill Henning: "Storage Impact of nullable varchar column?"
- Previous message: Jacco Schalkwijk: "Re: Table row count (cardinality)"
- In reply to: Klaus Aschenbrenner: "SQL Server 2005 Service Broker, transactions & scalability"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
