Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

recommendations for MAX_QUEUE_READER option on queue Expand / Collapse
Author
Message
Posted Tuesday, August 14, 2012 6:27 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:22 PM
Points: 411, Visits: 1,399
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
Posting Performance Based Questions - Gail Shaw
Hidden RBAR - Jeff Moden
Cross Tabs and Pivots - Jeff Moden
Catch-all queries - Gail Shaw


If you don't have time to do it right, when will you have time to do it over?
Post #1344650
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse