[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 773
  • Last Modified:

When to use SQL Server Service Broker

Well, during a chat two terms come up, Clustering and Broker.

I know a few things about Clustering but, Broker is totally an unknown term for me except it is for SQL Server 2005.

Would you please tell me some examples where Broker is being used and Cluster is?

Thank you.
0
idumlupinar
Asked:
idumlupinar
  • 5
  • 4
  • 3
4 Solutions
 
RiteshShahCommented:
Service Broker is a new feature in SQL Server 2005 that brings queuing and reliable messaging to SQL Server. Service Broker provides the plumbing to let you pass messages between applications, using SQL Server as the transport mechanism. Applications can use a single shared SQL Server database for this purpose or distribute their work across multiple databases.


whereas clustering is a concept of high availability and you get your whole database as a copy in your cluster. You can find many link online about both the topic.
0
 
RiteshShahCommented:
actually no direct comparison is possible as both are related to different topic. service broker is for messaging and clustering is for high availability.
0
 
RiteshShahCommented:
if you want to know more about service broker, have a look at

http://www.developer.com/db/article.php/3640771

0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
dportasCommented:
Service Broker has nothing to do with clustering in SQL Server.
http://msdn.microsoft.com/en-us/library/ms345108.aspx

0
 
idumlupinarAuthor Commented:
While using Clustering i need more than one server. Same condition goes for Service Brooker?
0
 
idumlupinarAuthor Commented:
Btw i woud appreciate if someone would fix my typo > Brooker > Broker
0
 
dportasCommented:
You don't necessarily need more than one server to use Service Broker. It is often used to send messages between servers but it can be used for any process that requires a message queue.

0
 
RiteshShahCommented:
"Btw i woud appreciate if someone would fix my typo > Brooker > Broker"

there is nothing like brooker in SQL Server in my knowledge
0
 
idumlupinarAuthor Commented:
Another question: Let's say a company has 40 client computers that running an application to connect to main database server and process data.

In this scenario a lot of data is transfered between server and clients, to get a better application performance is Broker enough? Or clustering should also be considered?
0
 
RiteshShahCommented:
again I have to repeat, both are different, clustering has nothing to do with application performance but as a messaging service you can use service broker there.
0
 
dportasCommented:
Clustering has nothing to do with improving performance.

Service Broker is just one type of messaging service you can use. Not necessarily faster or slower than something else - it depends what you are comparing it to.
0
 
idumlupinarAuthor Commented:
Thank you guys for your assistance.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now