Tuesday, January 17, 2012 5:20 PM
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 ?
Wednesday, January 18, 2012 3:33 PM
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.
Wednesday, January 18, 2012 3:36 PM
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.