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,
SQL Server 2008
February 3, 2011 4:23 PM
February 3, 2011 7:02 PM