Sql Server 2008 Serves Millionth Queue

Question

I am working on a framework for a new feature in our application. One of the requirements is that each user has a list of processes to process.

I plan to use SQL Server 2008 service broker to send users notifications on how to make goods.

But with the way the broker queue works, I cannot isolate messages for users in the same queue. I can only see after receiving the message. However, I want him to receive a message for the user who is calling him.

So, if I want to use brokerage services, I need a separate queue for each user.

Then I get millions of queues in the brokerage service.

I don’t have any broker service function that can allow me to have one queue, but receive messages with a filter?

Can SQL Server 2008 brokerage service handle millions of queues, and is it normal to do this?

Answer 1

, .. , , . Service Broker , . , " " , , , . RECEIVE . WHERE RECEIVE , , , .

- , () , , , , :

• . , , ( tempdb), tempdb ( ) ( , ). ( ).
• "", . , , , . http://rusanu.com/2008/08/03/understanding-queue-monitors
• , , , .
• RECEIVE , , WAITFOR(RECEIVE). WAITFOR , sp_configure 'max worker threads' , , WAITFOR .

/ "" /, . , , : , ( , ). -, , , - : , (milleage , , SQL-/ SP , SQL 2K5 SP3).

Service Broker (.. , DCM/COM +, Corba, Remoting ..). , SQL Server , . , SSB, , , , 50/50 SSB- , (.. , , ). , SSB , , , , .

, , , - . ( ) Service Broker ? , , - , , , .

: Service Broker team SSB

Answer 2

. - , RECEIVE - .

( ListenerCode varchar (10), ConversationGroup newid())

. - / . , . BEGIN DIALOG... RELATED_CONVERSATION_GROUP =....

ConversationGroup - , , . (. http://msdn.microsoft.com/en-us/library/ms166131.aspx.)

. , .

. , , , ; , , Task, Task - - , .