SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Broker a good option for scalability with desktop app?


Broker a good option for scalability with desktop app?

Author
Message
Sheldon Hull
Sheldon Hull
SSC-Addicted
SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)

Group: General Forum Members
Points: 456 Visits: 554
Have large amounts of IO right now with calculations saving millions of rows, updating millions of rows, and sometimes deleting millions.

I'm still at the 101 (plan on doing stairways)... and have a thought that broker might be a great option for increasing our scalability as we grow, and also help with the international clients connecting to a DB in USA experiencing serious latency issues. Does anyone have some simple real world examples of using Broker for scaling basic .NET actions (we use entity framework) and large DML actions? If 10 people are hammering a huge 22 million row table with massive deletes/inserts, I was thinking that broker offered an option to load balance sql server, whereas currently the only load balancing is our .NET engine thread count being reduced (which really doesn't load balance sql server)

I've done some reading, but was hoping for some experienced devs to shed light on some basic 101 examples on how broker can help scale a desktop app's actions, to help me cut through all the normal terminology and see if it's a good option to explore in detail to scale out our product. (all the way from single workstation with sqlexpress to multi-international sites connecting to DB in USA processing millions of actions a day)
SeeCoolGuy
SeeCoolGuy
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2187 Visits: 170
if you are still looking into this, I found a great little tutorial gets you from a to z

http://devkimchi.com/811/service-broker-external-activator-for-sql-server-step-by-step-1/

I simply have one outstanding question, how can ssbea be setup on a 3rd server to monitor the sql database queues?



--
Francisco
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search