Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Tuesday, August 14, 2012 6:27 AM


Group: General Forum Members
Last Login: Yesterday @ 6:17 AM
Points: 472, Visits: 1,666
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:

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