Implementing a chat using SQLServer Service Broker – how good an idea it is?

Tags:
Chat applications
SQL 2008
SQL Server
SQL Server 2008
We are designing a chat engine. That's basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session will be a new queue with text contributions to be delivered to all participants. Chat sessions will be created and terminated by the dozen every minute. Is this a scenario suitable for Service Broker? Thanks in advance, Marco

Software/Hardware used:
SQL Server 2008
ASKED: February 3, 2011  4:23 PM
UPDATED: February 3, 2011  7:02 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I’m not sure how good a solution SQL Service Broker will be, as messages can only be received from a queue once. You would have to have a destination queue for each user, which would cause you to have a very large number of database objects very quickly. I’m not sure if a queue technology which is dynamic is going to be the best solution.

If you wanted the messages persisted then a database table which stores the messages (possibly loaded via a SQL Service Broker Queue) would probably be a best option. Then just have the conversation users read from the table.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Marcofaustinelli
    [...] 5. Saturno’s answer regarding VPN access from out of state has been approved. 6. Mrdenny gave some insight to a member wondering how good an idea it is to implement a chat using SQL Server Service Broker. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following