Ramblings on all things SQL Server, Integration Services, Service Broker Reporting Services, TSQL, Replicaton, Full Text Search Spatial data and more by Simon Sabin : UK Microsoft MVP - SQL Server If you have any questions please feel free to contact me
I ask this because the SB newsgroup hasn't had a post for over 3 weeks. Which suggests not many people are using it?
I'm using Service Broker in a number of projects. I've found it pretty simple to get setup and once its running, I haven't run into any problems. It seems to be a pretty solid part of SQL Server 2005.
Maybe everyone else is finding it to be the same?
Hi Simon,
I use it for the plumbing for the plumbing in SQL 2005 server monitoring.
Anything that requires remote servering with broker is complicated and a pain in the ass to set up. Local you are fine but I think the argument people make is if its local only then just use a table yoruself....
Tony
I am a dba currently working with a developer on a deployment that will use a simple service broker configuration to setup a service between ssas,ssql,and ssis. Essentially we have some data that needs to be processed when it is required (asynchronously) and then made available in a reporting application, the users will be able to trigger this ssis based load and the data will be synchronized in ssas and viewed with office 2007. We have run into some minor issues in the administration (making it deployable, recreating, authorizing users and auditing progress) and queue handling. All of which were resolved with reasonable speed, but we did feel that the level of information provided in BOL was insufficient. The lack of a tutorial was also cause for concern. We were close to giving up and going with a different method. The main reason for this was the lack of quality "real-world" examples. We have since made some progress and found some decent examples that helped point us in the right direction. We are now getting ready to deploy this to our production environment.
Andrew.
Given the number of places I've found, trying to search for help on SSBS errors, I would agree that not many people are using it.
We (live support DBA team) have received a design using it that is ... interesting, to say the least:
we are using it to keep a legacy and 2 new-world databases in synch by sending messages acorss with each change on either side. All-in-all, the designer and developer came up with 19 different queues, just on 30 different message types, with 4 server working and sending the 100,000+ messages a day (24x7).
Seriously, that is the application that is the first usage of SSBS here. Surprisingly, there are some issues , amongst them a message syaing:
<Error xmlns="schemas.microsoft.com/.../Error">
<Code>-8428</Code>
<Description>The message type "SystemC/SystemA/Object/Action" is not found.</Description>
</Error>
((message type name sanitized))
Has anyone found anywhere with more detail on SSBs error codes and resolving them?
FYI: more detail on them here:
http://rusanu.com/2007/12/