Service broker as load balancing solution

Question

I read on the web that service broker could come in handy if planning load balancing solution with many sql servers computers.

However I can't find any well-written tutorial and with many example.

Can you help me ?

Thanks.

Answer 1

Get an eBook copy of "Pro Server Broker 2008" by Klaus for many good examples of doing this sort of thing.  Most any Service Broker application can be made to load balance across multiple SQL Servers by adding additional routes.  Here's a good simple example.  I suggest you setup a VM with 3 SQL Server instances and load balance the "data push" across two instances.  It's not hard to do at all.

http://msftsbprodsamples.codeplex.com/wikipage?title=SS2008%21Readme_FastDataPush&referringTitle=Home

-Roule

Answer 2

You should also take a look at examples of "Data Dependent Routing" such as: http://blogs.msdn.com/b/rushidesai/archive/2005/12/22/746825.aspx Search on that phrase and you will find many good examples that should fufill what you are trying to do.