Home Forums Programming Service Broker recommendations for MAX_QUEUE_READER option on queue RE: recommendations for MAX_QUEUE_READER option on queue

  • You may still be interested to read this blog post from the developers of SSSB which describes how to configure your service broker routes such that the calls to your service are distributed into multiple machines implementing the same service, i.e. create a load balancer so that the workload of importing the files can be distributed over multiple machines:http://blogs.msdn.com/b/sql_service_broker/archive/2008/07/14/using-multiple-routes-in-service-broker.aspx



    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]


    If you don't have time to do it right, when will you have time to do it over?